Autofill list

[wcurtis]

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?

 

[Gord Dibben]

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

 

[wcurtis]

Thank, just what I was looking for.

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