Replace cell of column with cells of other worksheet

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello,

I have the following problem.
In one sheet I have a table with imported keys from an
access table.
Now I want to replace these keys with strings that are in
a second worksheet. So eg when a cell in the 1st sheet
has value 2 it has to be replaced by eg "the second"...

How can I do this for all the cells of that column
automatically?

Thanks a lot.

Kristof
 
I'd suggest VLOOKUP, if it weren't for
all the cells of that column
automatically
Click to expand...

Find & Replace is probably out, since what works for "2" will affect 12, 20,
21, 22 ...

Depending on how many values/rows, you could (after sorting on the Key
column), select all 2s, type "the second", press CTRL+Enter, repeat as
necessary.

Post back with more info if this way would take you more than 5 mins.

HTH,
Andy

On the stereo this week ; Albinoni, Samuel Barber, Nirvana, Sinead O'Connor
 
Back
Top