Most valuable professional
  • Hot Topics

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 XXX date, the Column B value is YYY", 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 2, 2014.

For more resources for Microsoft Excel:

This article includes the following tags:

  • Excel
  • Microsoft Excel