Auto Replace

G

Gord

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?
 
Top