You could use the VLOOKUP Function with a table.

See Debra Dalgleish's site for info.

http://www.contextures.on.ca/xlFunctions02.html


Gord Dibben Excel MVP

On Wed, 16 Mar 2005 12:47:03 -0800, "TXTrailerdaddy"
wrote:

My work has all of its inventory priced in excel. I added a sheet that is a
quote page. Now, I would like to find a way to automate the data from the
pricebook over to the quote page using drop down lists. I figured out how to
make lists using the data validation, but I want to be able to migrate the
pricing, description and model numbers from the price book to the quote page.
Can anyone help?