In Sheet1 cell B1:

=if(isnumber(match(a1,sheet2!a:a,0)),"Yes","")

(and drag down)

Fester wrote:

Hello, I have scratched my head far too long and need some help.
Sheet1! column A contains short names. Sheet2! column A contains full
names. Here is what i would like to do. If the short name in Sheet1
cell A1 is found in any of the full names in Sheet2 column A then
Sheet1 cell = 'yes' otherwise = null.
Thanks,
Wes

--

Dave Peterson