I have a workbook with 2 worksheet, data & tour detail
data sheet like this
DATA FARE TABLE
A B C D
FROM TO KM FARE
1 DELHI JAIPUR 410 515
2 JAIPUR DELHI 410 515
3 DELHI GOA 1440 6550
4 GOA DELHI 1440 6550
5 DELHI PUNE 1800 7500
6 PUNE DELHI 1800 7500
And Travel Detail data sheet like this
Travel Detail
A B C D
FROM TO KM FARE
1 DELHI JAIPUR ??? ???
2
3
I want when i type in second sheet from and to column then km and fare are
auto fill from first sheet. I use vlookup fuunction but nested vlookup or using if statement in vlookup is cann't use . please help me.
Bookmarks