Adding another look up to a formula

coccio

Board Regular
Joined
Mar 19, 2002
Messages
140
<html><head><title>Excel Jeanie HTML</title></head><body>
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
 

Some videos you may like

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
Joined
May 29, 2008
Messages
836
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
Joined
May 28, 2005
Messages
48,400
Office Version
  1. 365
Platform
  1. Windows
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
 

Watch MrExcel Video

Forum statistics

Threads
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.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

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

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

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
Top