Excel: Date/Lookup/Reference Help

I have a calc sheet with several items, but for brevity's sake, I have dates for the entire year listed down Column A, and values corresponding down Column B. I'm trying to call up a reference from another cell, say C1, that will say either "given ABC date, the Column B value is DEF", where I can input the date that's being searched for in C2, or I can have it reference NOW(). I'm at a loss for this one, not even sure what angle to approach it from. Any suggestions?

This question generated 25 answers. To proceed to the answers, click here.

This thread is current as of July 02, 2014.

For more resources for Microsoft Excel