How to vlookup table array with wildcard?
Hi,
Could anyone please help if it is possible to create vlookup with wildcards in table array? or how to create formula to lookup values in attached sample case?
I need to transform extracted system account codes with related attributes into another system account format code. Column A are sample values of extracted codes and Column E are sample of transforming condition (The required attribute used for vlookup is the account code and the 2nd country name).
Sample Case.png
Can the table array for lookup (column E) be changed to make this easier?
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.
Temporary addition of accented to illustrate ongoing problem to the TT: Lá fhéile Pádraig sona dhaoibh
If you allowed the lookup array to be 2 characters for the country, then you could use something like this:
Screen Shot 2022-04-16 at 2.10.40 pm.png
Please Login or Register to view this content.
sample file attached
As a gesture off appreciation, you can click * Add Reputation at the foot of any of the posts of members who helped you reach a solution.
And finally, was your problem solved? if so, please click Thread Tools above the first post of your enquiry, then select [Solved]
Please try at B3
=INDEX($F$3:$F$8,MATCH(1,INDEX(SEARCH(SUBSTITUTE($E$3:$E$8,"_","_*_"),A3),),))
Hi, Thank you everyone for your assistance.
As the raw data will be extracted from system, the format cannot be changed.
I am not familiar with Index & Match but the Formula from Bo_Ry work for me.
I need to study more regarding these formula in order to apply for further usage.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks