VLOOKUP formula and a lookup table?

Visit Debra Dalgleish's site for info on VLOOKUP function to pull data based on
value. Note the downloadable sample workbooks.

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

Also see Debra's site for info on Data Validation selection lists for inputting
the data if need be.

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


Gord Dibben MS Excel MVP

On Tue, 24 Jun 2008 07:45:01 -0700, Erin Briana <Erin
wrote:

I have a huge list of numbers that each signify a different place. How can I
covert this is excel without doing it myself- looking up the location from
the code and typing it in- too time consuming.