Date formatting problems with hlookup

  • Thread starter Thread starter Grace
  • Start date Start date
G

Grace

I have had this kind of problem before and just don't understand the
problem. I have a couple of input cells that are date formatted. Then, I
have a bunch of hlookup functions that find that date in a row of dates and
read down N rows to find a value. I am getting N/A's right now and cannot
figure out the problem. All dates have, at least now, the same formatting
(*3/14/2001), so there should be no confusion as to it being a number. I
have tried other ones such as xx/mm/yyyy, also to no avail. Sometimes it
seems that, if I start from scratch and rewriter the equations, it fixes
itself. But this is so much work.

Someone please help!!

Grace
=HLOOKUP($C$18,IndexData!$D$42:$AI$77,Calcs!$S$303,FALSE)
 
Grace, you fool! A clue you should have thought of: Using false in lookups
means it needs an exact match. Which leads me to conclude that you may have
used 2003 in one of your inputs when you really meant 2004. It is not
finding a match becasue such a year old date is not within your range.

Formatting is not the problem - carelessness is!

Grace (your alter ego, the one who catches your silly mistakes)

Sorry folks!
 
Excellent post, Grace.

Wait, that wasn't so good.
You be quiet. I'm writing to Grace.
No, get your fingers off the keyboard and let me type!
No!
Yes!

(The voices in my head are pretty loud, too!)

(Your post made me laugh.)
 
<< (Your post made me laugh.) >>

Glad somebody had fun. The time I wasted trying to fix a non-problem made
me cry!

:<(
 
Back
Top