find and replace data
By messing around I stumbled on the vlookup function which does exactly what
I was looking for. I built an array on a seperate workbook and referenced it
in the vlookup function. Works like a charm.
"Rob" wrote:
How would I find and replace data conditionally. In the example below I
would like to take Workbook 2, A1:A3 and replace abc with 123. Something
like:
=IF(A1:A3=abc,substitue [123],"") but that doesn't work.
Workbook 1
| A | B | C |
1|abc | 123 | |
2|bcd | 234 | |
3|cde | 345 | |
Workbook 2
| A | B | C |
1|abc | XX | XX |
2|bcd | XX | XX |
3|cde | XX | XX |
|