Auto Replace
 

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?

Auto Replace
 

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?