First Time Posing-Vlookup to an array

[mciolino]

I created a spreadsheet and used reference arrays to lookup up tabs in the same file. For instance, I have a simple =vlookup(a2,MMP,2,false). I wanted to have the end user change the "MMP" array without having to go into the formula to make the change, perhaps typing in the array reference in one cell and having the formula look to that cell. I tried this formula =vlookup(a2,(vlookup(a5,tablecode,2,false)),2,false) but this didn't work. Any suggestions?

[Bob Phillips]

Maybe

=VLOOKUP(A2,INDIRECT(A3),2,False)

and put MMP in A3