Term Digit to Name Assignment Formula

[kas05j]

Hello,

I was hoping someone could help with a formula that would make my life easier. Here's what im looking for:

On a spreadsheet with 10 digit loan numbers in column 'A', I need a formula that I can drop into column 'B' that will look at the last two digits of the loan numbers in column 'A' and assign them to either Jim if the number is 00 - 49 or Kevin if the number is 50 - 99.

It's something similar to a more advanced version of =RIGHT(A2,2) that instead of spitting out a number, would just skip straight to either saying 'Jim' or 'Kevin'.

Anyone able to assist?

Thank you!

[Special-K]

=LOOKUP(RIGHT(A1,2),{"00","50"},{"Jim","Kevin"})