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

Return population for a City
If you have a list of cities in A2:A100, use Data, Geography. Then =A2.Population and copy down.

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
47,926
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,122,970
Messages
5,599,108
Members
414,288
Latest member
horizon2

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