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

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 Bplace cursor in
A1Paste SpecialValues.
This will replace the letters in column A with their numeric values.
Column B can then be deleted.

--
Regards
Roger Govier

"FROM SA" wrote in message
...
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