Excel 2007 : How do you get a vlookup formula to look at named range in a cell

Hi

In desperate need of help, I have several tables in a work sheet which consist of about 4 columns, each table I have a separate named range. In another worksheet I want to compare two sets of data. I want to do this by picking the named range of the two tables and then the data to feed through. I started to do this by a vlookup. The vlookup works if I type in the named range in the table array part of the formula. But it does not work if I refer the table array to a cell which has the name of the named range in it. Does anyone know why this is and how I can overcome this problem. It’s driving me crazy I just want to finish this report now.

Someone help me!!!!

Thank you so much!