In the HLOOKUP use Datevalue("8/21/08") for the lookup value. The dates are
stored as numbers with 1 equaling Jan 1, 1900. It doesn't matter how you
format the cell the number value will still be the same.

"Susan" wrote:

I have two spreadsheets and i am trying to do a HLOOKUP however i get a #N/A

The problem: They both have the date 10/1/07 but if i change the one date
to 9/30/03 it will do the look and when i change the dates to general, the
numbers match with the different dates but not if they are both 10/1/07.

Please help! Any solutions, what causes this?