Data input based on date list?
 

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

Data input based on date list?
 

=IF(ISNA(VLOOKUP(A1,F2:G100,2,0)),"",VLOOKUP(A1,F2 :G100,2,0))


"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

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

Data input based on date list?
 

Teethless mama,

PERFECT!!! Works like a charm. Thanks a bunch.
--
PatrickJ


"Teethless mama" wrote:

=IF(ISNA(VLOOKUP(A1,F2:G100,2,0)),"",VLOOKUP(A1,F2 :G100,2,0))


"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