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).
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top