IF and OR function help

[Sudarshan_1026]

I am using a IF statement and doing a vlookup to pull the value from another sheet and further trying to use the OR function to see if the lookup value is equal to any one of the OR values ..its throwing an error.

IF(VLOOKUP(A1,Sheet1!A:K,MATCH("ABCD",Sheet1!$A$1:$L$1,0),0))=OR("XYZ","ABC","EFG"),1,0)


Any help on this would be appreciated..

Sudi

 

[njimack]

=IF(OR(VLOOKUP(A1,Sheet1!A:K,MATCH("ABCD",Sheet1!$A$1:$L$1,0),0)={"XYZ","ABC","EFG"}),1,0)

 

[Sudarshan_1026]

=IF(OR(VLOOKUP(A1,Sheet1!A:K,MATCH("ABCD",Sheet1!$A$1:$L$1,0),0)={"XYZ","ABC","EFG"}),1,0)

Works as per my liking .. thanks a lot..

Sudi