Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Value Replacement
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
number replacement | Excel Discussion (Misc queries) | |||
Replacement for sumproduct? | Excel Discussion (Misc queries) | |||
#N/A Replacement | Excel Discussion (Misc queries) | |||
Replacement | Excel Discussion (Misc queries) | |||
Binder replacement for XP | Excel Discussion (Misc queries) |