Need Help with a Look up formula.

[Jithe]

Hi Guys,

I need some help regarding some work related calculations. I need a formula or a methodology.

Assume there are 2 tables

Table 1

Date	ID No	From	To	Distance KM
1st Jan	12546	Point A	Point B	5
2nd Jan	15976	Point B	Point C	?
3rd Jan	14753	Point A	Point C	?
4th Jan	15853	Point C	Point D	?

<tbody>
</tbody>

Table 2

From	To	KM
Point A	Point B	5
Point A	Point C	7
Point B	Point C	9
Point C	Point D	13

<tbody>
</tbody>

I need a formula for when I type the From and To locations in Table 1, it looks up the value corresponding KM in Table 2 and places the KM value in table 1.


Your help is greatly appreciated.

Thank You
Regards,
Jithe

 

[Aladin Akyurek]

Row\Col	A​	B​	C​	D​	E​	F​	G​	H​	I​	J​
1​	Date​	ID No​	From​	To​	Distance KM​			From	To	KM
2​	1st Jan​	12546​	Point A​	Point B​	5​			Point A	Point B	5​
3​	2nd Jan​	15976​	Point B​	Point C​	9​			Point A	Point C	7​
4​	3rd Jan​	14753​	Point A​	Point C​	7​			Point B	Point C	9​
5​	4th Jan​	15853​	Point C​	Point D​	13​			Point C	Point D	13​

In E2 control+shift+enter, not just enter, and copy down:

=INDEX($J$2:$J$5,MATCH(D2,IF($H$2:$H$5=C2,$I$2:$I$5),0))

 

[Jithe]

Dear Aladin Akyurek

Thank you so much this formula really solved my problem and made the calculations much more easier.

Regards,
Jithe

 

[Aladin Akyurek]

Dear Aladin Akyurek

Thank you so much this formula really solved my problem and made the calculations much more easier.

Regards,
Jithe

You are welcome. Thanks for the update.