On 2002-04-14 20:46, pipemaker wrote:
Heres a rough example
4/14 4/15 4/16 4/17 4/18 4/19
23 28 32 37 41 45
24 29 33 38 42 46
25 30 34 39 43 47
26 31 35 40 44
27 36
Something like the above. trying to do a horizontal lookup of the number and trying to get a return value of date. The array will not be sorted or anyhing like that. Not sure of the formula, just the basic hlookup wizard one.
On 2002-04-14 20:46, pipemaker wrote:
Heres a rough example
4/14 4/15 4/16 4/17 4/18 4/19
23 28 32 37 41 45
24 29 33 38 42 46
25 30 34 39 43 47
26 31 35 40 44
27 36
Something like the above. trying to do a horizontal lookup of the number and trying to get a return value of date. The array will not be sorted or anyhing like that. Not sure of the formula, just the basic hlookup wizard one.