VLOOKUP Function

For good instructions on how to do see Debra Dalgleish's site.

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


Gord Dibben MS Excel MVP

On Fri, 6 Feb 2009 12:03:02 -0800 (PST), Gord wrote:

Hey Folks,

I have a sheet I would like to create that includes a "auto replace".

Basically, if an entry is entered into column A I'd like column B to
have an entry auto-enter based on a list on another sheet.

So if I have a 2nd sheet that has all the possible entries for A and B
the sheet looks at what the user types in A and matches it to the item
in the same row, column b. The list would have several thousand
entires for reference.

Suggestions?