Hi,

Excel newbie here.

I have a spreadsheet that lists:
Place A, Place B, Distance
in columns A, B and C.

Is there a simple way, with VBA, to allow to:
-press a button which prompts the user to enter Place A and Place B; and
-returns the distance (column C) if there is a matching row (or an error message if not)

Thanks in advance!