Forum Discussion
Find Text in other cells
I have a large document that I am working on and want a "bulk" formula that is like the Find function. I need to check cells in a separate spreadsheet in the workbook for a match to a computer ID or ...
=IFERROR(INDEX($G$3:$G$7,MATCH(1,ISNUMBER(SEARCH($E$3:$E$7,A2))+ISNUMBER(SEARCH($F$3:$F$7,A2)),0)),"")You can try this formula. Enter the formula with ctrl+shift+enter if you don't work with Office 365 or Excel 2021. I've made an example which could be similar to what you are looking for. The number of names and ID numbers in the reference table can be increased as required. If there isn't a match IFERROR returns an empty cell.