Check dirty list for clean list content return true or false

[Just_Pat]

Hello again it's been a while,

I am running into a bit of an issue where I have to compare one column with "Clean Data" with another that has data with added baggage. The purpose of this is to figure out if the servers we have that should be backed up have been backed up by our agent.

Here is a test file I have been playing with: http://www.filedropper.com/testlist

So far none of the things I have tried have granted the expected results my last attempt was =IF(OR(COUNTIF([@[Server List]], "*"&BackupList[Backup List]&"*")), "Yes", "No") but that only returns the expected result if the "Dirty List" is an exact cell match which is sadly rarely the case. Is there a way to have it look for the cell value and have it ignore the irrelevant stuff?

 

[Fluff]

How about

=IF(COUNTIFS(BackupList[Backup List],"*"&[@[Server List]]&"*"),"Yes","No")

 

[Just_Pat]

How about

=IF(COUNTIFS(BackupList[Backup List],"*"&[@[Server List]]&"*"),"Yes","No")

Thank you so much this works!
If my problem was akin to finding a needle in a hay stack your solution is akin to a very large electro magnet... ok a very disproportionate analogy but I was stuck there so thank you

 

[Fluff]

You're welcome & thanks for the feedback.