# 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

VLOOKUP to Left?
Use =VLOOKUP(A2,CHOOSE({1,2},\$Z\$1:\$Z\$99,\$Y\$1:\$Y\$99),2,False) to lookup Y values to left of Z values.

#### skywriter

##### Well-known 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

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
3
Views
37
Replies
3
Views
26
Replies
6
Views
54
Replies
2
Views
149
Replies
6
Views
98