Okay, I have a workbook that I keep pricing for items in. Lets call it Fixture Price List. Now in that workbook I have worksheets, they are named faucets/tubs/toilets etc. on each sheet I have model names/numbers with the cost of that model to the right of the model name/number. Similar to this: Col A would be brand A models and Col B has the corresponding price. then I skip to Col D with another brand list and Col E with the corresponding price. With me so far? Okay, how can I get my pricing template to look in that workbook, on that worksheet for the price of the model I enter. Say I enter on my template in cell B7 "bigtub". Now I want cell C7 to display the price of the item I entered in B7 by searching the worksheet "tubs" in the workbook "fixtures". I can't use VLookup cause it wants to look in only 1 col and then return a value in the next col. How do I get excel to search that whole worksheet for the match of cell B7 then return the amount that is listed next to it?