Another one:

=ISNUMBER(MATCH(A2,Sheet1!F4:IV4,0))

Biff

"Augabog" wrote in message
oups.com...
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