|
|
#1
08-08-2019, 07:21 PM
|
|||
|
|||
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. 
|
|
|
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 |
Windows 10 
Office 2019
Threaded Mode