Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
walkenbach Climate_Data.xls vlookup
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Vlookup in vlookup - taking the result as array name | Excel Worksheet Functions | |||
Combine VLOOKUP and IF function so #NA isn't returned as a value from VLOOKUP | Excel Discussion (Misc queries) | |||
Vlookup -=VLOOKUP(F9,LookUp1!$A$2:$B$1504,2,FALSE) | New Users to Excel | |||
IF(AND(val1=VLOOKUP( );val2>=VLOOKUP( );val2<=VLOOKUP( );VLOOKUP( | Excel Worksheet Functions | |||
Vlookup info being used without vlookup table attached? | Excel Worksheet Functions |