A
AMaleThing
I'm coming across a problem searching using a formula as my LOOKUP
Value. e.g.
If my formula is:
=HLOOKUP(A1, B1:C10, 2, FALSE)
In one test where A1 = the date 2008/01/01 // HLOOKUP searches fine.
However, when A1 = a formula (i.e. =E1 or =today()) // HLOOKUP
reports #N/A.
Value. e.g.
If my formula is:
=HLOOKUP(A1, B1:C10, 2, FALSE)
In one test where A1 = the date 2008/01/01 // HLOOKUP searches fine.
However, when A1 = a formula (i.e. =E1 or =today()) // HLOOKUP
reports #N/A.