VLookup 2 instances in a table with 2 instances horizontal and vertical

[vivek.budhram]

Hi

Please help on the attached,

I have a table of kms from one location to another

I would like to verify kms(Distance) from one location to another

E.g From ALN to ROS is 676 kms

Tables of KMs (Kms Tabs)
Verify Kms (Loads Tabs)

I am looking for a formula to verify on Column D

Thank you in advance

[AliGW]

Try this:

=INDEX(Kms!$B$3:$D$5,MATCH(Loaded!A3,Kms!$A$3:$A$5,0),MATCH(Loaded!B3,Kms!$B$2:$D$2,0))=C3

[Shareez Saleem]

Another option:

Please Login or Register  to view this content.

[vivek.budhram]

Thank you, it works.

Is there a tweak in the formula, where I can bring back the digits from the table, so as to do a variance check

[JeteMc]

To get the numeric value omit the "=C3" from either of the formulas.
i.e. =INDEX(Kms!$B$3:$D$5,MATCH(Loaded!A3,Kms!$A$3:$A$5,0),MATCH(Loaded!B3,Kms!$B$2:$D$2,0))
Or =SUMPRODUCT(--(A3=Kms!$A$3:$A$5)*(--(Loaded!B3=Kms!$B$2:$D$2)),Kms!$B$3:$D$5)
Let us know if you have any questions.