Hi Guys, happy new year.
Just wanted to ask help. I wanted to get the value on the 2nd column if i will encode the code on the first column. please refer to the table below. Thanks a lot.
1st column 2nd column
ME or S 50,000.00
ME1 or S1 75,000.00
ME2 or S2 100,000.00
ME3 or S3 125,000.00
ME4 or S4 150,000.00
Your layout is not sensible. Don't put two possible values in one cell - list them separately - then it's just a case of a simple VLOOKUP or INDEX MATCH.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
Assume A1= M,M1,M2,M3,M4 or S,S1,S2,S3,S4
Try
B1Formula:
Please Login or Register to view this content.
If I helped, Don't forget to add reputation (click on the little star ★ at bottom of this post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Or try:
=CHOOSE(IFERROR(RIGHT(A1,1)+1,1),50000,75000,100000,125000,150000)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks