Data input based on date list?
=VLOOKUP(A1,F:G,2,FALSE)
entered into A2
"PatrickJ" wrote:
Need some help filling a cell with the corresponding percentage based on date.
Cell A1 is formatted to input today's date based on the computers date.
Formula: =TODAY()
Column F contains all the days of the year
Column G contains the percentages I would like to be at for each day of the
year.
What I would like is....When I open the worksheet when I get to work, I
would like cell C2 to somehow bring in the percentage that corresponds to
today's date. For instance, On 12 Feb when I open my spreadsheet, I would
like cell C2 to automatically update to 10.41% (The date 12 Feb is listed in
Cell F23, and 10.41% is listed in Cell G23.)
--
PatrickJ
|