Thread: Find In Set
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Rod Rod is offline
external usenet poster
 
Posts: 108
Default Find In Set

How can I do:

If A1 is in Set ["Joe", "Bill", "Clare", ""] then B1 = A1, else "Not Found"?

If A1 is "Bill" then B1 should be set to "Bill".
If A1 is "George", then B1 is "Not Found"

What I am trying to do is condense a potentially large conditional.

Thanks much!