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, 06:36 AM

p45cal

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

Office 2016

Expert

Join Date: Apr 2014

Posts: 956

You need to include the extra rows you're returning:
=INDEX(Sheet1!$B$1:$B$4,MATCH("*" & A10 & "*",Sheet1!$A$1:$A$8,0))
needs to be:
=INDEX(Sheet1!$B$1:$B$8,MATCH("*" & A10 & "*",Sheet1!$A$1:$A$8,0))

« 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 01:35 AM.