Forum Discussion
Solved
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 wou...
=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.
=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.
Pawn you are a genius!
This works great and is now deployed in our production workbook.
Thank you so much.
Best regards
This works great and is now deployed in our production workbook.
Thank you so much.
Best regards