searching a small text in a bigger text using VLOOKUP

		Microsoft Office Forums > Microsoft Excel > Excel
searching a small text in a bigger text using VLOOKUP

FAQ

Thread Tools

Display Modes

04-04-2019, 07:53 AM

p45cal

Windows 10 searching a small text in a bigger text using VLOOKUP

Office 2016

Expert

Join Date: Apr 2014

Posts: 956

In B1:

Code:

=IFERROR(INDEX(Sheet1!$B$1:$B$8,MATCH(TRUE,INDEX(ISNUMBER(SEARCH(A1,Sheet1!$A$1:$A$8)),0),0)),"")

A 255 character limit on MATCH with wildcards was breached.
If the smaller strings you're looking for ever exceed 255 characters and it fails, comeback for another (longer) solution.

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Text display size is too small	jim999	PowerPoint	1	01-02-2015 02:55 AM
Animation "get bigger" means low quality of my text!!!!	LillAlbyl	PowerPoint	1	12-04-2012 11:14 AM
searching for text in multiple excel files	roytom	Excel	2	07-30-2012 01:57 PM
Removing small blue-dotted text box	EuroOffice	Word	1	05-08-2012 05:43 PM
How to deactivate small images of text	Robert E	Drawing and Graphics	9	12-16-2009 04:01 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 06:29 AM.