Forum Discussion
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...
=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.