Need formula to calculate value from vertical & horizontal data

[amy_d2]

Dear All,

hope you all are doing well

i am in requirement of formula which can display desired result in sheet 2 cell B6, from my data in sheet 1

Pls have look & support

thanks,

[JohnTopley]

=INDEX(Sheet1!$B$2:$N$44,MATCH(Sheet2!$B$3,Sheet1!$A$2:$A$44,1),MATCH("ZONE " &Sheet2!$B$4,Sheet1!$B$1:$N$1,0))

[TMS]

Try:

Please Login or Register  to view this content.

[amy_d2]

hi John ,

that worked absolute

Thanks for the help .

[amy_d2]

Hi TMS ,

this also worked pretty well.

thanks for the help

[TMS]

You're welcome. Thanks for the rep.


Think I was trying to be too clever ... assuming there might be intermediate values. But it does also (try to) take into account the flat levels ... though I just realised I needed to multiply the value

[TMS]

Adjusted formula:

Please Login or Register  to view this content.