INDEX & MATCH ON 2 COLUMNS OF DATA

  • Thread starter Thread starter Joyce
  • Start date Start date
J

Joyce

My data looks like:

DIST TM NUMBER
4600 6 5000
3260 6 4000

I would like to INDEX/MATCH to pick up the number 4000 for
dist 3260 TM 6

does anyone have an idea of how to do this? I keep going
in circles here. Thank you.
 
=INDEX($C$2:$C$3,MATCH(1,INDEX(($A$2:$A$3=F2)*($B$2:$B$3=G2),0,1),0))

where F2 houses 3260 and G2 6.

A more officient way is to create an additional column...

In D2 enter & copy down:

=A2&CHAR(127)&B2

Now use:

=INDEX($C$2:$C$3,MATCH(F2&CHAR(127)&G2,$D$2:$D$3,0))

which is a less expensive formula.
 
Back
Top