• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Lookup last value using 2 criteria

Busymanjohn

Member
Hi Guys, I am having problems with a formula, I am trying to lookup a range of cells and return the last value in that range based on 2 criteria ,,, I can return the last value based on 1 criteria using LOOKUP(2,1/(B3:B16=F6),C3:C16), but how do I insert the 2nd criteria ,,,, also looked at Index & Match, doesn't quite get me the result ( although I could be missing something ). Sample file attached ..... the results I want to appear in cells G6 and G7 ,,, range is in A3:C16, criteria is F2 and F6 ( time range and date ). Any ideas?
 

Attachments

  • Sample Lookup.xlsx
    9 KB · Views: 9
Back
Top