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

Mark Forums Read

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 »

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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 04:46 AM.