F
Francois
Hello,
Here is what I want to do:
I have a table of two rows: one row for the months of the year, the second
one with values. Each month has 3 columns, the first one for a text value,
the other ones with number values, looks like that:
row 1onths, m: A1 july B1 july C1 july D1 august E1 august F1 august
row 2, values: A2 rain B2 34 C2 56 D2 sun E2 56 F2 45
this table is let say in a worksheet called table
I want to look up for a given month the first value of the month. Because I
do not want the other value i tried to use an array the following way:
HLOOKUP(lookedupmonth,{table!A1,table!D1;table!A2,table!D2},2,TRUE)
I cannot make it run, it seems that there a problem with the array there
however something like (excel help sample)
HLOOKUP(3;{1,3;"a","b"};2;TRUE)
return b
What is wrong with my array (I put lookeupmonth and first row as text)
Thanks for your help
Here is what I want to do:
I have a table of two rows: one row for the months of the year, the second
one with values. Each month has 3 columns, the first one for a text value,
the other ones with number values, looks like that:
row 1onths, m: A1 july B1 july C1 july D1 august E1 august F1 august
row 2, values: A2 rain B2 34 C2 56 D2 sun E2 56 F2 45
this table is let say in a worksheet called table
I want to look up for a given month the first value of the month. Because I
do not want the other value i tried to use an array the following way:
HLOOKUP(lookedupmonth,{table!A1,table!D1;table!A2,table!D2},2,TRUE)
I cannot make it run, it seems that there a problem with the array there
however something like (excel help sample)
HLOOKUP(3;{1,3;"a","b"};2;TRUE)
return b
What is wrong with my array (I put lookeupmonth and first row as text)
Thanks for your help