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
Bookmarks