Does anyone know if it is possible to look up a value in a named array based on a user input? I have a series of arrays that have been named and will be used to look up values. I want the user to enter the name of the array they want to use and then let Excel look up the value from the proper array. Using VLOOKUP I can enter the name of the array manually and it works (VLOOKUP(B25,test,8) where test is the name of the array). But if I want the user to enter the array to use (in place of "test" in the example) it blows up. My hope would be to have the user select the array they want from a list and use the result to pull the value from the proper array. Any ideas?