Hi,

In cell E2 of sheet2, use the following formula and copy down

=index(sheet2!$A$2:$B$5,match($c2&$D2,sheet2!$B$2: $B$5,0),1)

Now Copy all the values in column E and paste them as values. You may now
cut and paste column E on column B

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"palups" wrote in message
...
Hello, need help please. I have a tons of data in excel that I want to
change
the data in a certain column. Heres the scenario, supposed you have a two
worksheet SHEET 1 and 2. Data in Sheet 1 is the old one that we have to
replace by the data in sheet 2, but only the Col B in Sheet 1. Formula
should
replace the sheet 1 ColB with the sheet 2 ColA which have the same value
in
sheet 1 Col C,D and sheet 2 ColB. Thank you.

SHEET 1

A€¦€¦.....B€¦€¦€¦...C................D

21345 203 Manuel Cotto
65746 123 Juan Marquez
78695 003 Floyd Mayweather
65748 876 Ricky Hatton
65746 123 John Marquez
65748 876 Timmy Hatton
65746 123 Tom Marquez
21345 203 Ricky Cotto
21345 203 Jaun Cotto
65746 123 Archy Marquez
21345 203 Pedro Cotto


SHEET 2

A€¦€¦€¦...........B
3452 Manuel Cotto
2000 Juan, Marquez
1982 Floyd Mayweather
0564 Timmy, Hatton


palups