Forum Discussion
IamRahulV
Mar 07, 2023Copper Contributor
Split text then look up a table to check if exists
Dear all I need your help in figuring this out. Using this sample scan code: 8421 BCD. I am able to split it using the split text function I am then trying to check if the text part is there...
OliverScheurich
Mar 07, 2023Gold Contributor
=IF(SUM(N(ISNUMBER(SEARCH(A7,$A$2:$C$4)))),A7,"not found")
Does this return the expected result? Enter the formula as an arrayformula with ctrl+shift+enter if you don't work with Office 365 or Excel 2021.