Multiple If Thens or what?

  • Thread starter Thread starter accesscrazy
  • Start date Start date
A

accesscrazy

I have a spreadsheet with a chart. Instead of graphing a number, I want a
box on the front of the chart that looks at todays date and returns the
corresponding number from the spreadsheet.


Date Number
1/22/2009 135
1/30/2009 150
2/05/2009 152
2/10/2009 0

So.. Today's date is 2/03/2009 … I would expect to see the number 152 on
the chart.
 
I want a
box on the front of the chart that looks at todays date and returns the
corresponding number from the spreadsheet.
Click to expand...

Above can be done by Lookup or vlookup function.
If you are sure that your table has only 2 rows, lookup is easier.
In C1 type: Lookup(C2,A2:B5,) put your table inA1:B5 and in C2 type
today's date
Lookup has to formats this one uses lookup value and array.
If your date is always the last row in the column, there is an easier
way to spot it, but I don't remember it now.
 
Back
Top