| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| sorting 2 colums of numbers and incremening them down | Excel Discussion (Misc queries) | |||
| Mileage Claim Formula | New Users to Excel | |||
| List based on a date | Excel Discussion (Misc queries) | |||
| Printing data validation scenarios | Excel Worksheet Functions | |||
| How to filter and list data based on different data. | Excel Worksheet Functions | |||
Linear Mode
