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?

Use this formula in Sheet1 B1

=IF(ISNA(MATCH(A1,Sheet2!A:A,0)),"","OK")

--
If this post helps click Yes
---------------
Jacob Skaria


"Astro" wrote:

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?