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