P phil1ray Sep 29, 2004 #1 I would like to type text in a column, have excel surch a master lis and return the related information in the adjacent columns
I would like to type text in a column, have excel surch a master lis and return the related information in the adjacent columns
A Anne Troy Sep 29, 2004 #2 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/ ********************************
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/ ********************************
D Debra Dalgleish Sep 29, 2004 #3 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
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
