VLOOKUP

R

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?
 
P

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
 
Top