Complicated Nested If statement with 12 conditions and left function

Tune4love

New Member
Joined
Nov 29, 2017
Messages
4
Hello profs., I am having a long table containing about 20,000 rows (format is in numbers having 15 characters long), I need to get only the first 6 digits in the left for each number and then need to do an if statement with 12 conditions so to map each code with its correspondent company name to be as follow noting that i am using office 2013:

553667 it is "Company 1 name"
443213 it is "Company 2 name"
654345 it is "Company 3 name"
986543 it is "Company 4 name"
098837 it is "Company 5 name"
634533 it is "Company 6 name"
847564 it is "Company 7 name"
982474 it is "Company 8 name"
837464 it is "Company 9 name"
263535 it is "Company 10 name"
263637 it is "Company 11 name"
948373 it is "Company 12 name"

Appreciate getting your support and many thanks in advance
 
I found some interesting behavior in my testing.
I am using Excel 2010 at work, and Excel 2016 at home.
It appears that my original formula that I posted works on Excel 2010, but not on Excel 2016.
Very odd, I wouldn't expect that to behave like that...
 
Upvote 0

Excel Facts

Difference between two dates
Secret function! Use =DATEDIF(A2,B2,"Y")&" years"&=DATEDIF(A2,B2,"YM")&" months"&=DATEDIF(A2,B2,"MD")&" days"

Forum statistics

Threads
1,224,823
Messages
6,181,182
Members
453,020
Latest member
Mohamed Magdi Tawfiq Emam

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top