I have an imported file. The date of the file in D4 is 02/08/2007 -
02/15/2007. I am matching rows to each date, and to capture the beginning
date, in Q4 I have a formula =LEFT(D4,10). The result is 02/08/2007. Q1 =
Q4 (but formatted to drop the leading 0's). Here is the problem. When I put
in the formula =IF($B18=$Q1,$K18,"") I get a blank. But - if I TYPE in
2/8/2007 in Q1, I get the contents of B18. I have copied Q1 and past special
/ values - still get a blank.

Any ideas?

CaroleO