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.
Bookmarks