Vlookup

  • Thread starter Thread starter mstover34
  • Start date Start date
M

mstover34

Is there a way that you can have a VLOOKUP lookup three separate item
like store number, vendor number and amount? If so, I then would lik
all of these three factors to be included and then have the value tha
it returns is the dollar amount from the second workbook.

Thanks for your help
 
Hi

=SUMPRODUCT((StoreNumbersRange=StoreNumber)*(VendorNumbersRange=VendorNumber
)*(AmountRange))

When there are several amounts for StoreNumber and VendorNumber, then sum of
amounts is returned. And important is, that all (3) ranges must be of same
dimension (same number of rows).
 
Back
Top