I am trying to adjust my index and match formula so it will return a record in a corresponding field that only contain part of the name I am using as the match value. I am hoping to achieve this without using VBA. Any help would be appreciated.
I attached an example of what I am looking to achieve.
Thanks in advance.
Hi
Use VLOOKUP instead
Enter formula in B2 and copy across and down
Formula:
Please Login or Register to view this content.
v A B C D E 2 7 Clans - Paradise 7500 Hwy 177 Red Rock OK 74651 3 7 Clans - Paradis 7500 Hwy 177 Red Rock OK 74651 4 7 Clans - First Council 5 Buffalo Thunder 20 Buffalo Thunder Trail Santa Fe NM 87506 6 12 Tribes 7 Bucky's 1500 -AZ 69 Prescott AZ 86301 8 Cache Creek 14455 Hwy. 16 Brooks CA 95606 9 Camelrock Casino 17486A Co Rd 84 Santa Fe NM 87506
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
Thank you. That certainly worked. I see you used VLookup instead of Index Match. Out of curiosity, does the wild card function not work with Index Match?
Is there a way to modify the formula so the reverse is true. In other words, if the "e" in Paradise was missing from the Source tab instead of the primary tab the formula would still work? I just attached a revised file called Index Match Wildcard test2.xlsx.
Last edited by Perk1961; 09-08-2016 at 05:04 PM.
I am not sure I understand your question. The wild cards are helpful in situations when part of the string is missing otherwise you don't need to use it.
Here is a modified your INDEX/MATCH formula
Enter in B2 and copy across and then down
Formula:Please Login or Register to view this content.
I was able to use the formula on the source tab to match from the first page so that solved my follow up question. That said, for some reason the revised/modified index match formula you sent did not work like the previous vlookup formula.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks