[SOLVED] Enter column A and B values, return column C value?

[Wezzo]

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!

[JBeaucaire]

Sure. Or you can use an INDEX/MATCH/MATCH to get map distances from a table.

Here's some sample sheets showing exactly what you're looking to do.
Jerry Beaucaire's INDEX/MATCH Examples

Open the second sheet, the IndexMatch-Simple.xls and you'll see two ways to use a table format with an INDEX/MATCH/MATCH formula.

[Wezzo]

Brilliant, that's exactly what I'm looking for, cheers.

[JBeaucaire]

If that takes care of your need, use the Thread Tools menu to mark the this thread as [SOLVED].

(Also, use the blue "scales" icon in our posts to leave Reputation Feedback, it is appreciated. It is found across from the "time" in each of our posts.)