I need a formula that works like this.

Cell A1 has a name
Cell B1 has a date
Cell C1 has a number

If Cell A1 has a specific name and Cell B1 is do not exceed date, Cell
D1 is populated with C1.

For B1, it would be a date prior to 7/22/06, where 7/21/06 or 7/22/06
would populate D1, but 7/23/06 would remain blank in D1.

Please help.


--
Phatbob
------------------------------------------------------------------------
Phatbob's Profile: http://www.excelforum.com/member.php...o&userid=34371
View this thread: http://www.excelforum.com/showthread...hreadid=541494