Referencing data next to a date

  • Thread starter Thread starter Carina
  • Start date Start date
C

Carina

I have a cell with today's date, and I have a seperate row of dates. Can i
create a formulat that takes today's date, finds the date from the list of
dates, then populates the data next to the date in the rows?

Any help would be appreciated.
 
Hi Carina
Formula can't push information to other cell, it can only pull information.
the result is were you put the formula.
A macro could do it.
HTH
John
 
Thank you, but I am still not able to get a formula to work. I will try
explaining abain using cell references.

I have dates from 1/1/09 - 12/31/09 in C17:C332. In D17:D332 there is a
number that corresponds to each date. In A1 I have today's date (today()).
In A2 I want the formula to look at today's date (A1), find that date in
C17:C332 and give me the number next that corresponds to that date (D)
 
It would be helpful for you to post what you tried. The examples at the link
provided are pretty easy to follow.

From your description, I think you are looking for:

=VLOOKUP(A1,C17:D332,2,FALSE)
 
Thank you Glenn, That worked perfectly.

Glenn said:
It would be helpful for you to post what you tried. The examples at the link
provided are pretty easy to follow.

From your description, I think you are looking for:

=VLOOKUP(A1,C17:D332,2,FALSE)
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Populate Cell with another cell, but only if the date equals today 4
Excel Date Count 2
Function to Return a Date Value Q 4
Conditional formatting dates 3
Rounding date field up to next first of month, with existing formu 5
Match Function And Display Row Number 2
Excel Display certain dates 9
Check inputdate, then retrieve data to fill in chart from dated co 2

Back
Top