Using Variables in Vlookups.

Hello,

Got a good one for anyone that can help. I have a Vlookup that I need to do where the table that it is looking on varies depending on another variable. So my lookup loks something like this:

Vlookup($C$8,(Variable Table),2)

I've tried to use a nested Vlookup to find the right table, but that didn't seem to work as all I got was a #Value error. Can anyone give me any information on hwo to get a variable to work withing a vlookup?

Thanks in advance,

Lael Buchanan