VLOOKUP using dropdown list for table array

I would like to creat some sort of formula similar to a VLOOKUP where a cell reference to a dropdown list can be used to alter the location of where to cross reference.

I have multiple name defined ranges in a dropdown which would be used for the table array part of the formula. However, I only get errors with the current formula. Hope this makes sense. I have attached an example that might help.

Thanks,
Mike