excel help

Home Forum Chat Forum excel help

Viewing 5 posts - 1 through 5 (of 5 total)
  • excel help
  • Premier Icon Stoner
    Subscriber

    Create a reference table somewhere where the corresponding values are listed next to each other and use vlookup or match&offset to return the correct one.
    Or use a long-winded conditional statement.

    My preference is the former.

    Markie
    Member

    Vlookup would be my starting point…

    Edit: as stoner just said! Like him, I’d shy away from an epic if statement, they can be dreadful to alter or debug!

    thanks I’ll try that later ans will no doubt be back with further questions!!

    Premier Icon Stoner
    Subscriber

    I’m here all morning 🙂

    how can I get excel to convert a kids key stage 3 level into a numerical value eg 8 = 13, 7a=12, 7b=11 7c= 10 6a= 9 etc and back again?

Viewing 5 posts - 1 through 5 (of 5 total)

The topic ‘excel help’ is closed to new replies.