formula problems

salopian

New Member
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

Last edited:

Excel Facts

Enter current date or time
Ctrl+: enters current time. Ctrl+; enters current date. Use Ctrl+: Ctrl+; Enter for current date & time.
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

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.

Replies
5
Views
129
Replies
1
Views
161
Replies
6
Views
269
Replies
1
Views
372
Replies
2
Views
233

1,203,213
Messages
6,054,196
Members
444,708
Latest member
David R__

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back