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
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
Hi, try:
'=VLOOKUP(C9,D23:H26,LOOKUP(E8,E22:H22;{2,3,4,5}),FALSE)
Estige,
Many thanks for your great help.
But it turns error formulae , any function is missed out ?
Hi, probably something gone wrong in my manual translation to English syntax. OK in the attached workbook?
Try this,
Please Login or Register to view this content.
Estige,
you deserve excel expert.
Thank you so much.
I too not an english man.
Thank you kvsrinivasamurthy for your support and timings.
It works
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks