I am working with a spreadsheet with only 3 columns. Column A = Product Number; Column B = Date; Column C = Price (the Price on the Date found in column B).

The problem I am running into is that I am working with ~50 Product Numbers with 3 years of price data for each. The data is located in a separate spreadsheet. The data for each product is located in separate tabs.

For example, the sheet may look like following:

Product Number.......Date.................Price
1456......................01/12/02...........???
1456......................02/06/05...........???
83734....................11/22/03............???
83734....................03/01/04............???
12.........................05/30/02...........???

I want to use a vlookup to pull in the price for the Date in Column B, but I don't know who to make the formula point to the correct tab.

Thanks for any help.