formula problems

[salopian]

I have 2 worksheets and I need some help, please!

-- removed inline image ---


In Worksheet 1 i require a number added in Column L that is calculated from the data in Columns G and J against the data in the second Worksheet entitled TNPA.
In the example above L5 should read 1; L6 should read 2 and L7 should read 4.

I applied the formula =IFERROR(INDEX(TNPA!$C$2:$G$6,MATCH(G5,TNPA!$B$2:$B$6,0),MATCH(J5,TNPA!$C$7:$G$7,0)),"")
but it returns nothing!


-- removed inline image ---

TNPA Worksheet

Any help or ideas greatly appreciated!
Many thanks

 

[skywriter]

I have 2 worksheets and I need some help, please!

-- removed inline image ---


In Worksheet 1 i require a number added in Column L that is calculated from the data in Columns G and J against the data in the second Worksheet entitled TNPA.
In the example above L5 should read 1; L6 should read 2 and L7 should read 4.

I applied the formula =IFERROR(INDEX(TNPA!$C$2:$G$6,MATCH(G5,TNPA!$B$2:$B$6,0),MATCH(J5,TNPA!$C$7:$G$7,0)),"")
but it returns nothing!


-- removed inline image ---

TNPA Worksheet

Any help or ideas greatly appreciated!
Many thanks

Your link, if it is a link, isn't working.


This would be easier with some sample data.
One suggestion would be to put each of your match functions in a cell by themselves and see what numbers they are returning and then correlate them to the index data and that will probably show you what the problem is.