Hi gillesda

Use the Vlookup formula

See Debra's site
http://www.contextures.com/xlFunctions02.html


--
Regards Ron de Bruin
http://www.rondebruin.nl


"gillesda" wrote in message ...
I need to use a number in a column on the first worksheet to find
corresponding text that goes with that number on another worksheet. This is
all in the same workbook, and it has to be alphebetized afterward.