Index match that matches down the column in a cell

[tonywatsonhelp]

Hi everyone,
I need to do an index match type lookup, but the column I'm doing the matching down changes according to the number

So instead of "=INDEX('Item ID'!A:A,MATCH(B3,'Item ID'!D:D,0))" the 'Item ID'!D:D, the column is determined by the number in column E so if E3 = 6 it would be Column F

any ideas how to do this?

 

[jasonb75]

Maybe

=INDEX('Item ID'!A:A,MATCH(B3,INDEX('Item ID'!A:F,0,E3),0))