Replacment in excel

F

FROM SA

hi all

how i replace onr colum in excel

for example if i have sheet in excel include the following data
a
a
a
a
a
b
b
a
c
c
a
d
b
c
a
f
a
f

and i have other sheet include the following

a 12
b 22
c 4
d 55
e 23
f 12


how i replace all first sheet data by the make all a cell 12 and all b cell
22 (data from sheet 2)

with out make replacement one by one
 
R

Roger Govier

Hi

In cell B1 of the first sheet enter
=VLOOKUP(A1,Sheet2!A:B,2,0)
Hover over the bottom left corner of cell B1 till you see the fill handle (a
small solid black cross)>Double click
This will fill the formula down column B for as far as data extends in
column A.

If you want, you can then copy the whole of column B>place cursor in
A1>Paste Special>Values.
This will replace the letters in column A with their numeric values.
Column B can then be deleted.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top