Thread: Troubleshooting Searching for a Word in a List
View Single Post
 
Old 08-08-2019, 07:21 PM
Guinness Guinness is offline Windows 10 Office 2019
Novice
  
Join Date: Aug 2019
Location: Deep South
Posts: 16
Guinness is on a distinguished road
Default Troubleshooting Searching for a Word in a List
=LOOKUP(2,1/SEARCH(Bead!A$2:A$94,E4),Bead!A$2:A$94)

Could anyone please help me see why I'm receiving either a #N/A or "Shell" in this workbook instead of "Glass"? I have ~850 records and most are working fine, but there are a few that aren't. Thanks.
Attached Files
File Type: xlsx Shell Errors.xlsx (14.1 KB, 9 views)
Reply With Quote