Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
HLOOKUP using variable columns
I'm trying to reference a variable column rather than a specific column # in
my HLOOKUP formula. A1 B1 C1 D1 A2 1/6/2009 Today's Date A3 1/6/2009 Start Date A4 A5 1/5/2009 1/6/2009 A6 1/5/2009 1 0 A7 1/6/2009 2 1 I would write my formula as =HLOOKUP(B3,$B$6:$D$7,?,FALSE) In place of the ? I've tried to reference a cell that contained a whole number but that didnt work. I want to be able to copy and paste this formula for several different individuals based upon their starting date & not necess. column D every time. Any ideas here? Please use literal interpretation (A6=A6,B6=1/6/2009,C6=2). |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to sum columns by variable criteria | Excel Discussion (Misc queries) | |||
HLOOKUP using multiple columns | Excel Discussion (Misc queries) | |||
Graphing Variable-length columns | Charts and Charting in Excel | |||
Hlookup in other columns | New Users to Excel | |||
How to see columns from which values were not returned by HLOOKUP functions? | Excel Worksheet Functions |