Adding an OR statement into formula

Hi guys,

I have this formula:

Please Login or Register  to view this content.

I need to add an OR statement so that it says if the original statement says "10. Closed" as it does now OR "01. Green". Can anyone help me do this?

Thanks
d

Try

=IF(OR(VLOOKUP(B2,Sheet1!$1:$65536,'dashboard data'!Q2,FALSE)={"10. Closed","01. Green"}),"---",VLOOKUP(B2,Sheet1!$1:$65536,'dashboard data'!Q2,FALSE))

cheers! that works