| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Hlookup for row 3 and 4
I am getting crazy trying the following:
row 1 cell A1 =hlookup(A2:F3;max(A2:F2);1) (closed with shift ctr enter) row 2 cells 23 25 43 10 0 12 25 (as results of sum(A4:A50 - B4:B50 - etc.) row 3 cells aa db ac ya fg ig rs (text) I get always as result "rs" What am I doing wrong? Thank you feor help -- dilettante |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| HLOOKUP and SUM | Excel Discussion (Misc queries) | |||
| hlookup | Excel Discussion (Misc queries) | |||
| Hlookup | Excel Discussion (Misc queries) | |||
| Hlookup/max value? | Excel Worksheet Functions | |||
| HLookup ??? | Excel Discussion (Misc queries) | |||
Threaded Mode
