If I have one Cell that will always start with either 103, 201, or 103
I want to another cell to read either Auto, II or NYC based on the beginning of that first cell
103= II
201= Auto
301= NYC
Is this possible?
If I have one Cell that will always start with either 103, 201, or 103
I want to another cell to read either Auto, II or NYC based on the beginning of that first cell
103= II
201= Auto
301= NYC
Is this possible?
If the first cell is A1, put this in the second cell:
=LOOKUP(NUMBERVALUE(LEFT(A1,3)),{103,201,301},{"II","Auto","NYC"})
Try
=IF(LEFT(A1,3)="103","II",IF(LEFT(A1,3)="201","Auto","NYC"))
If the cell value 'Always' begins with 103, 201 or 301 then you only need to test the first digit.
=CHOOSE(--LEFT(A1),"II","Auto","NYC")
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks