Forum Discussion
Match a tag name
Hi Team
I am trying to match a tag name in Column "A" to a tag name in Column "B" that has data with comma delimiter formatting within and return a "Yes" in Column "C" if found.
Any help would be greatly apricated.
See attached sample.
Best regards
Frank
=IF(SUM((--ISNUMBER(SEARCH(","&[@Tags]&",",","&Table13[Tags]&",")))*("yes"=Table13[EOL]))>0,"yes","")You can try this formula. Enter the formula with ctrl+shift+enter if you don't work with Office365 or Excel 2021. The formula returns "yes" if there is at least one device with the tag from column A of the Runbook Meeting Schedule and "yes" in column EOL of the Planning list.
For example there are two devices which run on EOL and have the tag ACT.
6 Replies
=IF(AND(OR(ISNUMBER(SEARCH($A$2:$A$209,B2))),ISNUMBER(SEARCH(",",B2))),"Yes","")You can try this formula. Enter the formula with ctrl+shift+enter if you don't work with Office 365 or Excel 2021.
OliverScheurich - it worked up until Row 72. Because my “A” column goes to row 209 and “B” only has data up until row 72 the remaining of “A” was not compared.
For example the entry of cell A204 "WhatsUpGold" is found in cell B68 and the formula returns "yes" in cell C68. Isn't this the expected result?
