Combined Index Match

[matty_lou82]

Hi,

I have a table of data that I need to look up data from based on 2 lookups, the first vertically and the second horizontally. The lookup will be based on 2 dropdown lists based on the values within these sections. So rather than using a standard Index_Match, I need some kind of blended Index_Match insread where I can lookup a specific value based on 2 dropdoens, rather than just 1.

Here is a picture, the 2 dropdowns are the sections in Orange:

 

[jasonb75]

It's still a standard INDEX and MATCH formula, assuming that the dropdowns are fed from the row and column headings an error trap should not be needed

=INDEX($C$7:$G$11,MATCH($B$2,$B$7:$B$11,0),MATCH($C$3,$C$6:$G$6,0))

 

[matty_lou82]

It's still a standard INDEX and MATCH formula, assuming that the dropdowns are fed from the row and column headings an error trap should not be needed

=INDEX($C$7:$G$11,MATCH($B$2,$B$7:$B$11,0),MATCH($C$3,$C$6:$G$6,0))

Hi Jason, thank you so much for getting back to me

I have tried the formula and unfortunately it doesn't appear to work. To confirm, both the dropdowns are taken from the row and column headings, using validation lists.

Thank you again,

Matt

 

[sparky2205]

Just a typo I think Jason:
=INDEX($C$7:$G$11,MATCH($B$2,$B$7:$B$11,0),MATCH($C$2,$C$6:$G$6,0))

 

[matty_lou82]

Just a typo I think Jason:
=INDEX($C$7:$G$11,MATCH($B$2,$B$7:$B$11,0),MATCH($C$2,$C$6:$G$6,0))

Thank you both! So helpful!

 

[jasonb75]

Just a typo I think Jason:

Oops, my bad thanks for correcting it

 

[Haree]

Hey Matt

Kindly try this
=INDEX($B$6:$F$10,MATCH($B$2,$B$6:$B$10),MATCH($C$2,$B$6:$F$6))

This is assuming your data row ends at B10 and data column ends at F6

Hope this Helps