SOLVED

Display text based on multiple lists

Occasional Visitor

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 Replies
best response confirmed by Bruxer (Occasional Visitor)
Solution

@Bruxer 

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

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

Nic