Index Match indexing different columns depending on cell value

[tonywatsonhelp]

Hi Everyone,
ok so i want to do an index match, (or equivalent) down a column but index different column depending on what's in a cell

So currently i have this,

"=INDEX('Questions Raw'!I:I,MATCH($AB100,'Questions Raw'!$H:$H,0))"

but this part ( 'Questions Raw'!I:I ) is only correct if AC100 = "a"
if it = B its 'Questions Raw'!J:J
if it = C its 'Questions Raw'!K:K
if it = D its 'Questions Raw'!L:L
if it =E its 'Questions Raw'!M:M


is there an easyier way that loads of ifs???

please help if you can thanks

Tony

 

[Fluff]

How about

=INDEX('Questions Raw'!I:M,MATCH($AB100,'Questions Raw'!$H:$H,0),CODE(UPPER(AC100))-64)