Vlookup and named ranges ...

Hi ...
I've searched but I didn't find.
I have this spreadsheet to find distances between cities.
Problem is that a lot of places on Earth share the same name.
There are Los Angeles's all over the place.

So to pick the right one, I think I first need to enter the name of the country it resides.
So in D10 I type USA. Then, in the list of cities, I mark all cities in the US, and name that area USA

Going back to F10, where a v.lookup function is planned to lookup Los Angeles in the named area by fetching the name of the area from D10. It works when I key the name directly in the formula, but I don't seem to get it to work when trying to use the area name residing in D10.

Any thoughts?
See attached image.Image 328.png

You probably need INDIRECT

I'm not familiar with the language of the formula in your picture, so in English it would look like

=VLOOKUP(E10;INDIRECT(D10);2;FALSE)

Hehe ...
You beat me to it ...
Found it myself too.
Yes that worked fine.
Thanks for your time.

This thread should be marked solved ...
I don't seem to find out how to ...

You're welcome.

Hi,

I don't recognise the formula you are creating there, but instead of having Los Angels in a named range called USA, why not get all the cities and append the country so that all the Los Angleses are unique. For example

Los Angeles USA
Los Angeles Spain
Dublin Ireland
Oslo Norway

instead of
Los Angeles
Los Angeles
Dublin
Oslo