VLOOKUP with multiple lookup_value's

[AJT]

I am trying to do a VLOOKUP with a Cruise ship and a specific date it leaves
port and I want it to return the sales for those specific two lookup values.
For example, We have sales for the specific week of 2/17/08 and I want my
VLookup to return the sales for that week with not just the Ship Name(SOO),
but also the day it leaves port (6/24/09).

 

[Jacob Skaria]

Suppose you have sales in ColC. Ship in ColA, port in ColB

=INDEX($C$2:$C$10,MATCH(1,($A$2:$A$10="Ship")*($B$2:$B$10="date"),0))

Replace Ship and Date with cell references.


If this post helps click Yes

 

[Jacob Skaria]

or if you are looking to SUM Colc with the matches then use sumproduct

=SUMPRODUCT(--(A2:A6="ship"),--(B2:B6="date"),C2:C6)

If this post helps click Yes

 

[T. Valko]

Try this...

Ship names in column A
Dates in column B
Sales in column C

Use cells to hold the criteria:

E1 = some ship name
F1 = date of interest

=SUMPRODUCT(--(A1:A10=E1),--(B1:B10=F1),C1:C10)