If Statments: Want TRUE if a value = any of the given values
Try one of these:
If there might only be one match
=COUNTIF($F$4:$IV$4,A2)
or....if $F$4:$IV$4 may contain duplicate values
=--(COUNTIF($F$4:$IV$4,A2)0)
Is that something you can work with?
***********
Regards,
Ron
XL2002, WinXP
"Augabog" wrote:
How do I make an if statment that says: If Value A2 is equal to any of
the Values in Row 4 (F4:IV4), then it is true, otherwise false.
I was putting: =IF(A2=Sheet1!F4:IV4,"1","0"), but it doesn't seem to
recognize the simple F4:IV4 as "any of these values is true".
Thanks,
Kerry
|