Forum Discussion

vicsalt's avatar
vicsalt
Copper Contributor
Mar 15, 2024

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)

 

Formulas and Functions
  • NikolinoDE's avatar
    NikolinoDE
    Mar 15, 2024

    vicsalt 

    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.

  • NikolinoDE's avatar
    NikolinoDE
    Gold Contributor
    Mar 15, 2024

    vicsalt 

    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.

Resources