A
atran
Hi,
I'm looking to do a lookup based on a few variables. In the tabl
below, Date, Product, Location and Price are columns A, B, C &
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 table
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 wil
check the Product, then look in the appropriate sheet and lookup th
appropriate date and location and return the Price from Table 2.
Is this possible? I do not mind manual intervention on some parts i
this is required.
Much thanks
I'm looking to do a lookup based on a few variables. In the tabl
below, Date, Product, Location and Price are columns A, B, C &
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 table
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 wil
check the Product, then look in the appropriate sheet and lookup th
appropriate date and location and return the Price from Table 2.
Is this possible? I do not mind manual intervention on some parts i
this is required.
Much thanks