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 |