INDEX? MATCH?
This works, too! Thank you so much. Connie
"Dave Peterson" wrote:
=isnumber(match(a1,sheet1!c:c,0))
will return True or false
=if(isnumber(match(a1,sheet1!c:c,0)),"Yes","no")
Connie Martin wrote:
This is a simple formula, I know, and I wish the formula wizard was simple,
too!! Can't get it, so I need someone's help.
In cell C1 in Sheet2 I need a formula that will look at the numbers in Col.
A in the same worksheet and see if the number is in Col. C of Sheet1, and
return "Yes" if it is, and "No" if it isn't. Simple enough, I think. Thank
you. Connie
--
Dave Peterson
|