Index and Match formula

I am trying to find out why my answers come out as zero. Can you tell me where I have gone worng with my index and match formula.
I am trying to get a value from 2 seperate criteria. The formula in question is on sheet 2 column E.

Thanks for your assistance...

Sorry that is because I have taken this from another worksheet. On this particlaur one it should be $E$6.

Thanks for your assistance

Mark

Try this formula in E8:

=IFERROR(INDEX(Lookup!$B$3:$H$5,MATCH($E$6,Lookup!$A$3:$A$5,0),MATCH($A8,Lookup!$B$2:$H$2,0)),0)

then copy down.

Hope this helps.

Pete

Pete,

You are a star !!

Thanks for your help. What had I got wrong ?

Mark

Well, there were a few things ...

It's probably easier to compare my formula with the one you had, to see what changes have been made. In addition to the AF6 referred to above, you were also trying to match on L8, so that needed changing. Also, MATCH returns the relative position of the matching cell in a range, but your ranges were mixtures of full-column and full-row, as well as shorter ranges with a different starting point than column A or row 1.

Hope this helps.

Pete