Excel 2007 : VLOOKUP with Indirect

[Lissu]

To start with I want to apologize if I don't use the proper English words to explain my problem - I'm using the Sweidsh version of Excel 2010.

I have several named areas (ranges?) with different lists of codes. I want to use VLOOKUP to find a certain value in the second column in a specified area. So far so good.

I now would like to improve my formula by putting the name of the area in a cell an then use the cell content for VLOOKUP to search the correct list.

I tried the INDIRECT, but I can't get it to work - is it at all possible?

I would appreciate any tips and tricks, thank you in advance...

Rgds
Lissu