HLOOKUP Can't Search by Lookup Value

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.
 
N

Nayab

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.

If the range in which u r searching has the date as String and not as
Date then you will #N/A. If you enter the dates as dates, this will be
resolved
 
A

AMaleThing

If the range in which u r searching has the date as String and not as
Date then you will #N/A. If you enter the dates as dates, this will be
resolved

Is there a way to change the cell be a date and not a date-String. My
cell contains a reference (=E1) to another worksheet.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top