Forum Discussion
Autofill Cell
I have a table , lets assume the following to aid simple understanding
Column A = Date from 1st to 31st
Column B = Qty Packed each corresponding day
C1 = Value Packed today
So based on todays date in a range of dates (1st to 31st (Column A) it takes a corresponding value from the same row in Column B (qty Packed for that date) and place it in C1, C1 will be overwritten every day . For reference C1 is linked to a daily report on another sheet
E.G on today is the 15th March (B15) and we packed 1000 parts (B15) C1 should show 1000.
I hope this helps. and appreciate any assistance
I have used the statement below to sum totals in a column based on today - I assuming i need something like this but not a sum
=SUMIF(C26:C46,"<"&TODAY()-1,F26:F46)
You can achieve the desired functionality using the VLOOKUP function combined with the TODAY function to dynamically fetch the value packed for today's date from column B and display it in cell C1.
Here's how you can do it:
Assuming:
- Column A contains dates from 1st to 31st.
- Column B contains the corresponding quantity packed for each date.
- Today's date is March 15th.
In cell C1, you can use the following formula:
=VLOOKUP(TODAY(), A:B, 2, FALSE)
Here's how the formula works:
- TODAY() function returns today's date (March 15th).
- VLOOKUP searches for today's date (March 15th) in column A (dates) and returns the corresponding value from column B (quantity packed). The 2 in the formula specifies that it should return the value from the second column (B) of the lookup range (A:B).
- The FALSE argument in VLOOKUP ensures an exact match for today's date.
After entering this formula in cell C1, it will display the quantity packed for today's date (March 15th) from column B. This value will update automatically every day based on the current date.
The text was created with the help of AI.
My answers are voluntary and without guarantee!
Hope this will help you.
Was the answer useful? Mark as best response and like it!
This will help all forum participants.
- NikolinoDEGold Contributor
You can achieve the desired functionality using the VLOOKUP function combined with the TODAY function to dynamically fetch the value packed for today's date from column B and display it in cell C1.
Here's how you can do it:
Assuming:
- Column A contains dates from 1st to 31st.
- Column B contains the corresponding quantity packed for each date.
- Today's date is March 15th.
In cell C1, you can use the following formula:
=VLOOKUP(TODAY(), A:B, 2, FALSE)
Here's how the formula works:
- TODAY() function returns today's date (March 15th).
- VLOOKUP searches for today's date (March 15th) in column A (dates) and returns the corresponding value from column B (quantity packed). The 2 in the formula specifies that it should return the value from the second column (B) of the lookup range (A:B).
- The FALSE argument in VLOOKUP ensures an exact match for today's date.
After entering this formula in cell C1, it will display the quantity packed for today's date (March 15th) from column B. This value will update automatically every day based on the current date.
The text was created with the help of AI.
My answers are voluntary and without guarantee!
Hope this will help you.
Was the answer useful? Mark as best response and like it!
This will help all forum participants.
- vicsaltCopper ContributorThankyou works a treat