Hi minkus,
I would think you could create a lookup table to do this, and use a nested if/vlookup to find the first 1 or 2 characters in the list.
How many different "originations" are there? And do they always have either 1 or 2 letters at the beginning? Do any have 3, 4, or more?
If you had a table that had all of your origination codes ("S", "T", "ST", etc.) in column A, and their associated city in column B, you could use something like:
This basically says that if Excel returns an error looking for the first character in the lookup table, then return a match for the first two characters, otherwise return a match for just the first character. Hopefully that makes sense and helps you in your efforts.
Bookmarks