G'day guys
Here is my dilemma.
I am constantly writing in my logbook for work vehicle but it has some very repetitive locations.
What I need help with is how to return xx if a1 = X and B1 = Y the return (predefined answer)
Example: if my from location is Egypt and my destination location is London then return cell J1 which would be my route kilometers or miles depending country.
Maybe a Vlookup type thing.
TIA
Bookmarks