A
Astro
Is there a function I can use for the following:
Sheet1:
A B
1 John OK
2 Mark
3 Dan OK
Sheet2:
A
1 John
2 Dan
So if "John" from Sheet1 can be found in Sheet2 column A, then display OK at
Sheet1 column B Row 1. Can this be done?
Sheet1:
A B
1 John OK
2 Mark
3 Dan OK
Sheet2:
A
1 John
2 Dan
So if "John" from Sheet1 can be found in Sheet2 column A, then display OK at
Sheet1 column B Row 1. Can this be done?