Going beyond 7 Nested If Arguments

Hi
My apologies for what I’m sure this must be a well worn question, but I cant seem to find an answer in old threads.

Im needing to achieve what an 11 argument nested if would manage, ie:

Please Login or Register  to view this content.

Col E of the spreadsheet houses a total of 365 entries of a combination of the above 11 letters/numbers shown in the top line. Depending on the letter, the corresponding value needs to appear in Col N.

I’ve heard of Case If statements, but wouldn’t know how to implement them. I’d be grateful for any sort of assistance.

Many Thanks

Supdem

You need HLOOKUP()... see that in Excel Help for more...

e.g

=HLOOKUP(E10,$A$1:$K$2,2,0)

where E10 contains first entry to look up in row A1:K1 and return value from A2:K2.

adjust ranges, references as needed. and copy down