Hi All
This time Looking for a formula as it is mentioned in the table attached excel sheet.
as per the table, we need to come to the conclusion of "Process" as mentioned below.
when ES=Y
Region=APAC
Country=Korea/China
The "process" should reflect as "APAC Language ES"
The same way we need to accommodate all the conditions.
If anyone can help me, it will be a great help.
Attachment : Formula.xlsx
Regards
Arindam
Here is how I would do this.
1. Insert a column at D and place this formula in there and copy it down. =CONCATENATE(C2,A2,B2)
2. You will need to build your lookup table to include every combination instead of using items like China/Korea or All, you will need to list each country.
3. Insert a column at N and place this formula in there and copy down. =CONCATENATE(K5,L5,M5)
4. In Column E, place this formula and copy down. =VLOOKUP(D2,$N$5:$O$10,2,0) Note you will have to change the range N5:O10 to the actual range you arrive at after completing step 2 and 3.
Good Luck with this.
Alan עַם יִשְׂרָאֵל חַי
Change an Ugly Report with Power Query
Database Normalization
Complete Guide to Power Query
Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
Thanks a lot..this really very much helpful for me...
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks