View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
B Golden B Golden is offline
external usenet poster
 
Posts: 3
Default Vertical Lookup from a List

I am attempting to have a variable reference to the table array in the
vlookup function. I have created a pull down list in A1 and want the results
of the pull down list to then reference the name of a corresponding table
array lookup. It seems that I have to either reference the name itself in
the formula and it is not able to reference the results of pull down menu A1.

Any help is appreciated!

--
BDG