| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Lookup-value in HLOOKUP?
It seems you can't use a formula (eg "0") as the lookup value in VLOOKUP or
HLOOKUP. Is there a way around this? I have month by month sales data for a few thousand items for 36 months and I am trying to establish how many months ago was the last sales activity. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| lookup combine vlookup with hlookup | Excel Worksheet Functions | |||
| HLOOKUP, VLOOKUP, LOOKUP??? | Excel Worksheet Functions | |||
| 'IF','LOOKUP' or 'HLOOKUP'? | Excel Worksheet Functions | |||
| HLOOKUP - Adjusting the lookup value... | Excel Discussion (Misc queries) | |||
| Multiple lookup values in =HLOOKUP | Excel Discussion (Misc queries) | |||
Threaded Mode
