Troubleshooting Searching for a Word in a List

		Microsoft Office Forums > Microsoft Excel > Excel
Troubleshooting Searching for a Word in a List

FAQ

Thread Tools

Display Modes

08-08-2019, 07:21 PM

Guinness

Windows 10 Troubleshooting Searching for a Word in a List

Office 2019

Novice

Join Date: Aug 2019

Location: Deep South

Posts: 16

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

Shell Errors.xlsx (14.1 KB, 11 views)

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How to return the full string (entire word) when searching with wildcards in word vba	scienceguy	Word VBA	13	03-23-2019 03:27 AM
Searching for part, BUT NOT ALL, of a word...	MikeWebster2000	Outlook	2	09-27-2013 06:35 AM
Searching Multiple PowerPoint & Word Files	BobbyAre	PowerPoint	14	08-12-2012 06:52 AM
Finding or searching ^ character in word document	shahin3121	Word	2	03-05-2012 06:16 PM
Searching for Word Documents	jocaan	Word	2	09-08-2011 11:48 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 02:16 AM.