Hello everyone
I'm new to Excel, so this might be an easy question to answer. I've calculated the distance between 10 cities around the world. You can find the distances in the blue colored matrix. Now, I've added two dropdown menus that contain a list with the 10 cities, in cell A20 and B20. I want Excel to show me the distance between the selected cities, which I already calculated in the blue colored matrix, from the dropdown menus in cell C20.
Capture.PNG
Don't mind the data outside the blue colored matrix.
Thanks in advance!
Bookmarks