I need to do a vlookup that takes a string from one cell and then tries to find that string (embedded in a larger string) in the table array
Essentially I imagine this involves the FIND funtion at some point.
Attached is an incredibly simplified example of what I’m looking for.
Thanks in advance, for your help
Try this:Formula:
Please Login or Register to view this content.
Comfirm with crtrl+shift+enter (not just enter)
Never use Merged Cells in Excel
Hi,
Thanks for the fast response. It works perfect on the example.
Apologies but I should have provided a better example that was truer to my specific problem.
Attached, is my updated example to reflect my real problem (im not trying to return a number so SEARCH() doesn't work)
Again, help is greatly appreciated.
Kind regards,
Zak
1. Comfirm formula with CSE
2. you can achive that by VBA code
1. I was using CSE incorrectly. Apologies.
2. Is there a separate forum area for requesting help with VBA code?
It's OK staying here, hope someone can figure way out
Okay great.
For anyone visiting with VBA knowledge, please see my most recently uploaded example.
Basically -
I need my existing Index/Search formula to use an 'alrea.dy exists in the cell above' logic when grabbing a value from column G and putting it in column C(see example, attached)
Here, try this:
Please Login or Register to view this content.
Only be careful: It looks for exact string.
In your original example there was criteria Authorise Customer Bill Invoice Adjustment with space at the end.
So it won't find it in Filenames.
You can ignore spaces with something like this:
Edit: Used Trim as JP suggestedPlease Login or Register to view this content.
Last edited by zbor; 12-21-2012 at 04:26 AM.
using trim might be safer. btw for the original question I reckon vlookup with a wildcard would be easier
=vlookup("*"&b3&"*",$f$3:$g$10,2,false)
Josie
if at first you don't succeed try doing it the way your wife told you to
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks