Autofill Cell

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.