Finding text amongst longer text using vlookup (Take 2)

**coach.32** · 07-04-2013, 08:52 AM

Unlike my previous post, I have attached a small sample file that does relate to the data mentioned below.
In this sample I would like to have the VLookup formula return a value of "C:\Bill" which is the desired folder.
I would like the VLookup to search Column B to see if it contains the text in the partial column (i.e Reaper).
Could someone tell me what the VLookup is or if I may need to use Index, MATCH.
Thank you for any help offered.

**Richard Buttrey** · 07-04-2013, 08:56 AM

Hi,

Try

Formula:

Please Login or Register  to view this content.

**Rambo4711** · 07-04-2013, 08:58 AM

Duplicate posting
http://www.excelforum.com/excel-form...g-vlookup.html

**Pepe Le Mokko** · 07-04-2013, 09:00 AM

Perhaps

Please Login or Register  to view this content.

**Richard Buttrey** · 07-04-2013, 09:08 AM

This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

Are there any extenuating circumstances since an infraction is hovering?

Thread Closed.

With 39 posts you should know the rule about duplicate postings.