| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Find and replace with a lookup
I have two corresponding columns:
Column A 145431 145432 145433 Column B DEFECT.1234 DEFECT.12351 DEFECT.1236 And another non-corresponding column that I want to modify with data from Column A above: Column A2 4645645DEFECT.1236131546 412312DEFECT.123487416 21168754DEFECT.1235155646 I want to search for a match between columns B and A2, and replace the matching string within A2 with the corresponding value from A. Thanks in advance. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Find nth occurrence and replace with ":" | Excel Worksheet Functions | |||
| find replace format | Excel Discussion (Misc queries) | |||
| Find & Replace in VB macro | Excel Discussion (Misc queries) | |||
| Find and replace of word causes change of font formatting | New Users to Excel | |||
| VB Find and Replace | Excel Worksheet Functions | |||
Threaded Mode
