Should be easy. i have 8 digit invoice numbers. Each 8 digit number starts with one of three 4 digit ID codes. Depending on the first 4 digits, I want a different "company" to show up.
First seems to work fine. Any help on wrapping this up?
=IF(E6>"1NCC","North Carolina",IF(E6>"2ALA","Alabama",IF(E6>"3SCC","South Carolina")))
Thanks for the help.
Last edited by arlu1201; 02-18-2014 at 01:18 AM.
OK dont get too upset - I changed your thread title to be more descriptive of what you want.
=IF(left(E6,4)="1NCC","North Carolina",IF(left(E6,4)="2ALA","Alabama",IF(left(E6,4)="3SCC","South Carolina")))
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
not upset at all. Apparently I'm already breaking rules! I usually save that for the second date.
Thanks for the hand and the help!
That was a *wink* at your original title
Thanks for the feedback
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks