Check out help on VLOOKUP or visit Debra's site for how-to's.

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



Gord Dibben MS Excel MVP

On Sat, 31 Jan 2009 12:06:01 -0800, wcurtis
wrote:

Can I type in or select from a drop down menu a barcode or name and have the
rest of the sheet autofill? Example:
Barcode: 123456 and have autofill the model number, serial number, price,
date?
If I already have the information in another workbook how will it retrieve
the info I am looking for?