Display text based on multiple lists

[Bruxer]

Hi there,

I'm having difficulty getting the following to occur; 

If the value in cell B4 matches any value in list 1, the text "Yes" is displayed in cell C4

If the value in cell B4 matches any value in list 2, the text "No" is displayed in cell C4

If the value in cell B4 does not match a value in any list, cell C4 is left blank

Any help on this would be great. 

Thanks, 

Nic 

[#2 · Accepted solution]

@Bruxer 

=IF(ISNUMBER(MATCH(B4,list1,0)),"Yes",IF(ISNUMBER(MATCH(B4,list2,0)),"No",""))

[#3]

This is great! Exactly what I needed. Thanks for your help.

Nic