Data entry help

phil1ray · Sep 29, 2004

I would like to type text in a column, have excel surch a master lis
and return the related information in the adjacent columns

Anne Troy · Sep 29, 2004

Use Vlookup. Here's a sample, that also has a sample download:
http://www.theofficeexperts.com/excel.htm#TheDreadedVlookup

**** Hope it helps! ****

~Dreamboat
Excel VBA Certification Coming Soon!
www.VBAExpress.com/training/
********************************

Debra Dalgleish · Sep 29, 2004

You can use a VLookup formula to return a value from a table. There are
instructions in Excel's Help, and here:

http://www.contextures.com/xlFunctions02.html