INDEX? MATCH?
Thank you! This works wonderful. Found two numbers that weren't in my list!
Great! That makes life easier!! Connie
"Pete_UK" wrote:
Try this, Connie:
=IF(ISNA(MATCH(A2,Sheet1!C:C,0)),"No","Yes")
then copy down as required.
Hope this helps.
Pete
On Nov 10, 4:34 pm, 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
|