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 Name, the cell that I am checking against is not "clean" but is a summary of the service ticket so it may only have the name or ID so VLookup is not an option as there is nothing to anchor it to. I have added samples below of the data I will be working with. I have around 350 items to check which is why Find is not an efficient option.
=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.
- for a match to a computer ID or Name, ？
can you share some dummy data which can paste to Excel and your expected result?
re:have the name or ID so VLookup is not an option
What do you mean exactly?
Can you provide a specific example?
Sorry,I can not get it.
