VLOOKUP

[Roger Chetty]

I would like to return one set of results using 2 lookup values. For example
when looking for a certain product by location, one may find, a list that
contains 10 different rows of the same product, with the quantity in each
location of the product in a separate row.

I need to be able to pull out stock levels by warehouse, with each product
listed as a row, and the physical stock for each warehouse to be listed as a
column. Is this possible?

 

[Pete_UK]

Yes, this is possible - probably using an INDEX/MATCH combination
rather than VLOOKUP.

Please post further details showing how your data is laid out, and I'm
sure someone will be able to help.

Pete

 

[Dave Peterson]

Take a look at Debra Dalgleish's explanation:
http://www.contextures.com/xlFunctions03.html (for =index(match()))