Multiple Criteria Lookup

[tmurphy686]

Criteria:

B5: 1
U4: 12/01/2013


Data:

(A) (B) (C) (M)
Name 01/01/2013 02/01/2013 12/01/2013
Apple 2 3 1
Bottle 4 2 3
Cat 1 1 2

Answer:
Apple from NAME column

Explanation:
The index/match has to look across row 2 from the data for the date (U4) while matching the corresponding number/name.

Thanks!

[ConneXionLost]

How about:

Please Login or Register  to view this content.

[tmurphy686]

One follow-up:

Criteria:

F5: 1

Data:

(A) (B)
Name YTD
Apple 1
Bottle 2
Cat 3

Answer:
Apple from NAME column

Explanation:
A lookup does not work backwards - what would the corresponding index/match be.

[ConneXionLost]

Try this:

Please Login or Register  to view this content.