I hope I can explain it well: I have one big table which has the following data:
Amstelveenseweg 1040 Bijlmerdreef 677 11,3 Amstelveenseweg 1040 Charlotte Brontestraat 46A 11,7 Amstelveenseweg 1040 Elysee 46,9 Bijlmerdreef 184C Stationsstraat 18A 12,5 Bijlmerdreef 677 Elysee 53,5 Bijlmerdreef 794 Frederik Hendrikstraat 30 17,1
1e column is the first street 2nd column is the destination street and the 3rd column is the distance between column 1 and 2.
Now my problem and question: In my daily work I have to keep up were I drive and the distance:
This sheet looks likes this:
Geleenstraat Hogevecht 188B 9,1 Hogevecht 188B Amstelveenseweg 1040 12,5 Amstelveenseweg 1040 Elysee 47 Elysee Geleenstraat 48 Totaal 116,6
What I want is that if I fill in the First two horizontal streets (Geleenstraat and Hogevecht 188B Excel fill in the distance from the data from the existing tabel.
I have tried Vlookup,Index, match but nothing works. I hope someone can help me I hope it is clearly defined Englishis not my mother language, Thanks for someone help looking forward for the solution