How to Vlookup from two input with multiple ranges ?

[kalanjeya]

I am looking for the formulae in E9.

I may change the value in E8 as 1.5 or 2.5 or 4 or 6
I may scrolldown C9 as it set out there. I need to know the farmulae in E9.

Thank you

[estige]

Hi, try:
'=VLOOKUP(C9,D23:H26,LOOKUP(E8,E22:H22;{2,3,4,5}),FALSE)

[kalanjeya]

Estige,
Many thanks for your great help.
But it turns error formulae , any function is missed out ?

[estige]

Hi, probably something gone wrong in my manual translation to English syntax. OK in the attached workbook?

[kvsrinivasamurthy]

Try this,

Please Login or Register  to view this content.

[kalanjeya]

Estige,
you deserve excel expert.
Thank you so much.
I too not an english man.

[kalanjeya]

Thank you kvsrinivasamurthy for your support and timings.
It works