Thanks but I'm having a little trouble with the formula. I put 3/20/06
in cell A1. In sheet "actuals" I have 3/4/06 through 3/31/06 starting
in cell B4 and ending at B34. I then have values in cell's C4 through
C34 that match up with each day.
When I enter the date in A1 of sheet "main flash" I want the value
that's next to the corresponding date in sheet "actuals" to appear in
cell B5. So for example if I type 3/20/06 in and in the "actuals" sheet
the value (found in cells C4:C34) for that date (dates in B4:B34) is
500, 500 will then appear in cell B5 of the "main flash" sheet
--
Weasel
------------------------------------------------------------------------
Weasel's Profile:
http://www.excelforum.com/member.php...o&userid=27206
View this thread:
http://www.excelforum.com/showthread...hreadid=524879