IF formula to replace initials with numbers

Hi guys

Firstly I have attached my spreadsheet so it is a bit more clearer as no doubt my query will sound a lot more complicated then it actually is!

I have a spreadsheet and within this is a table containing rankings from 1 to 34, with an initial beside each of them on the next cell column.

I also have on cells D4 to D7 initials which are taken from the table. What I am wanting to achieve is in column V be able to convert the initials from D4 to D7 into numbers corresponding with what the initials are ranked in the original table. Im sure this is possible, just not sure how to go about it.

Any tips would be greatly appreciated.

Thanks
Julie

Hi Julie,

Your description doesn't quite agree with the sample you provided; however, if I assume you're referring to the jockey initials in column "T" (vice "D") then perhaps this formula in cell V4 (autofill down) might help:

Please Login or Register  to view this content.

As a side note, if you switched your columns "A" and "B" around, you'd be able to accomplish the same result using a VLOOKUP function instead of the INDEX ~ MATCH functions.

Cheers,

Another approach in V4 with VLOOKUP

=VLOOKUP(T4,CHOOSE({1,2},$B$2:$B$35,$A$2:$A$35),2,FALSE)