Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
looking a value in an array text values
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
return values from an array based on matching text value | Excel Worksheet Functions | |||
Array: Counting multiple values within array | Excel Worksheet Functions | |||
Use array to return array of values | Excel Worksheet Functions | |||
Count how many different text values in an array. | Excel Worksheet Functions | |||
How to use an array or matrix to return text vs. numeric values | Excel Worksheet Functions |