Index/match:look up two values from a worksheet

[Mvaldesi]

All right, I'm using an INDEX/MATCH function to look up two values from a worksheet and match them BOTH in a record on named table from another worksheet in the same book and return the value from a cell in the applicable record from said table. Below is the formula:

=INDEX(LaneSummary,MATCH(A4,Origin,0)&MATCH(B4,Dest,0),3)

It works, as in it returns data, but it is evidently matching A4 and B4 to the wrong record on the Origin and Dest tables and returning the WRONG data. Help??

[TMS]

You might get more assistance if you posted a sample workbook with some typical, but not necessarily real, data.

Regards

[daddylonglegs]

Try Like this

=INDEX(LaneSummary,MATCH(1,INDEX((A4=Origin)*(B4=Dest),0),0),3)

[Mvaldesi]

Thanks for the help; I didn't get it to work for me though; I found the easier solution was to merge the two cells I'm referencing and do a simpler look-up of the one cell. Thanks again, though!