ChristineRutter
New Member
- Joined
- Aug 12, 2002
- Messages
- 16
Hi, I wonder if anyone can help me.
I'm trying to create a mileage spreadsheet for my husband.
In col 1 is the from location, col 2 is the to location and col 3 is the mileage between the 2 locations.
What I want to do is lookup this mileage from another sheet which is set up the same way, but includes the mileage see eg below
Sheet 1
Col1 Col2 Col3
Southend Chelsea ????
Sheet 2
Col1 Col2 Col3
Southend Chelsea 48
The lookup sheet will have lots of froms and tos and will be updated if a trip wasn't on there before.
How can I do this please?
Thanks/
I'm trying to create a mileage spreadsheet for my husband.
In col 1 is the from location, col 2 is the to location and col 3 is the mileage between the 2 locations.
What I want to do is lookup this mileage from another sheet which is set up the same way, but includes the mileage see eg below
Sheet 1
Col1 Col2 Col3
Southend Chelsea ????
Sheet 2
Col1 Col2 Col3
Southend Chelsea 48
The lookup sheet will have lots of froms and tos and will be updated if a trip wasn't on there before.
How can I do this please?
Thanks/