I am tryng to use the chart climate_data.xls from
http://spreadsheetpage.com/index.php...data_workbook/
I am having a problem with vlookup. Everything looks fine except that the
only column in the data table that has any values is the column in which the
option buttons are. The code is
=VLOOKUP(City1,INDIRECT(DataTable),COLUMN(),FALSE)

There are 4 buttons 1-4. there are also two validation drop down lists of
cities. The data for each button is has a name; precipitationData,
SunshineData, WindData, and temperatureData. First you select a city in each
validation list. Then you click on buttons 1-4 and you can compare the values
for wind, sunshine, etc.
The data is supposed to populate the chart's data range from the Vlookup
code above. But when I enter the code all I get is #Value!. When I look at
the Vlookup function for Lookup_Value which is "city1" there is a red
comment, ="#Value!
Does it have something to do with the cell's format. I tried changing that
but nothing. The Table_arra = Volatile, Col_Index_Num ={1}, and the
Range_Lookup = False.
It works in the sample chart from the Walkenbach site, but I can't get it to
work. Thanks.

Jackie