To whom it may concern,
I am new to excel, and have stumbled across your wonderful site.
My query, if anyone can help is the following:
I am trying to set up a worksheet whereby two critera when matched from a drop down list will populate cell 'x' with a coressponding answer.
if you have Destinations then a From and To column with various locations listed below, then in a thrid column you have an output cell which is kilometres
What formula can i use to match the various location 'to' and 'from''s with the correct kilometre match?
Any assistance would be MOST helpful,
Thanks in advance,