MellissaD wrote:
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


You could use INDEX MATCH

In this example the Client Owner is entered in E2 and Client Number in F2

12-1000 AB 13 1000 CD
13-1000 CD
12-1001 EF
13-1001 GH




=INDEX($D$2:$D$5,MATCH(E2&"-"&F2,$C$2:$C$5,FALSE))

<
edvwvw

--
Message posted via http://www.officekb.com