I am creating a spreadsheet that uses our 7 digit client number to track who
the client actually belongs to depending on the first 2 digits of the number.
For example, the number could be 10-50000 where the 10 designates that it is
Jane's client or 12-50000 in which the 12 designates that it is Mary's
client. I'd like to be able to only enter the client # in one cell, then
have the name auto fill in the next cell. Any tips on a formula that will
get that done for me? Thanks!
Mellissa