Now I get error 2042. What does this error mean?

I have adjusted the values such that there will always be a match, bu
that doesn't seem to help.

Here is the action I want:
Given a supplied date value, I am trying to find the row who's dat
matches in column 'A', and then return a corresponding value in colum
'C'.

What a I doing wrong

--
ricm
-----------------------------------------------------------------------
ricm9's Profile: http://www.excelforum.com/member.php...fo&userid=3461
View this thread: http://www.excelforum.com/showthread.php?threadid=54386