Adding another look up to a formula

coccio

Board Regular
Excel Workbook
ABCDEFGHIJK
1AgeGenderL1L2L3AgeLGender
218M00.450.518l2M0.45
319M20.470.5
420M30.580.5
521M40.250.5
622M50.30.5
723M70.40.7
824M60.40.7
918F30.80.5
1019F40.90.4
1120F50.10.3
1221F61.10.2
1322F71.50.9
1423F91.50.8
1524F60.50.9
Sheet

</body></html>
For H2 & I2 I can match the two to get the value but I want add another item for excel to look up Column B so I want match H2, I2 , J2. How do I add it to this formula

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.

c_m

Well-known Member
Try:
=INDEX(A1:E15,MATCH(H2&J2,A1:A15&B1:B15,0),MATCH(I2,A1:E1,0))
confirmed with Control+Shift+Enter

coccio

Board Regular
Works out great thank you

Try:
=INDEX(A1:E15,MATCH(H2&J2,A1:A15&B1:B15,0),MATCH(I2,A1:E1,0))
confirmed with Control+Shift+Enter

Peter_SSs

MrExcel MVP, Moderator
If your Male/Female sections have identical age values, as in your sample, you could possibly use a non-array formula like this. The '7' in the formula reflects the 7 age values for each of M/F.

Excel Workbook
ABCDEFGHIJK
1AgeGenderL1L2L3AgeLGender
218M00.450.520L2F0.1
319M20.470.5
420M30.580.5
521M40.250.5
622M50.30.5
723M70.40.7
824M60.40.7
918F30.80.5
1019F40.90.4
1120F50.10.3
1221F61.10.2
1322F71.50.9
1423F91.50.8
1524F60.50.9
16
Lookup

Replies
7
Views
74
Replies
1
Views
79
Replies
0
Views
119
Replies
5
Views
96
Replies
1
Views
54

1,127,334
Messages
5,624,087
Members
416,010
Latest member
NJT

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