Hi,
I am after a formula that will look at col A in Sheet1 and try and find a match from either Sheet 2 and 3, as per below screen shots
I am after a formula that will look at col A in Sheet1 and try and find a match from either Sheet 2 and 3, as per below screen shots
Excel Workbook | ||||
---|---|---|---|---|
A | B | |||
1 | Code | MATCH | ||
2 | AU1H | |||
3 | RTYU | |||
4 | FGFH | |||
5 | ERTE | |||
6 | RYYT | |||
Sheet1 |
Excel Workbook | ||||
---|---|---|---|---|
A | B | |||
1 | CODE | MATCH | ||
2 | AU1H | TEST1 | ||
3 | RTYU | TEST2 | ||
4 | RYYT | TEST4 | ||
5 | ||||
Sheet2 |
Excel Workbook | ||||
---|---|---|---|---|
A | B | |||
1 | CODE | MATCH | ||
2 | ERTE | TEST3 | ||
Sheet3 |