Hi,
I'm looking to do a lookup based on a few variables. In the table
below, Date, Product, Location and Price are columns A, B, C & D
respectively.

Table1
Date Product Location Price
Jan1 A ZZ
Jan1 A YY
Jan1 B ZZ
Jan1 B YY

I also would have separate sheets for each product with tables
containing the price for each Product:

Sheet "Product A"
Table 2
Date Location Price
Jan1 YY 2
Jan1 ZZ 3

I would like to do a lookup for col D (Price) in Table 1 where it will
check the Product, then look in the appropriate sheet and lookup the
appropriate date and location and return the Price from Table 2.

Is this possible? I do not mind manual intervention on some parts if
this is required.

Much thanks!


--
atran
------------------------------------------------------------------------
atran's Profile: http://www.excelforum.com/member.php...o&userid=24540
View this thread: http://www.excelforum.com/showthread...hreadid=381355