Formula to automatically fill an Excel table
Solved
Matthieu
-
Vaucluse Posted messages 27336 Registration date Status Contributeur Last intervention -
Vaucluse Posted messages 27336 Registration date Status Contributeur Last intervention -
Hello,
I am using Excel 2010 and I am looking for a formula that allows me,
based on an existing "X" table located in sheet 1 (Example: Column A = Order No, Column B = Order Date, Column C = Delivery Date) ,
to automatically fill another "Y" table in sheet 2 (Example: Column A = Order No, Column B = Delivery Date) only with the rows from the X table where the "Delivery Date" fields are filled in column C.
Basically, I am currently manually filling in 2 tables, the first one being an order book and the second one a delivery book, and I realize that a lot of data is common, so I am looking for that elusive formula that will allow me to populate the rows of my delivery book automatically when a date is entered in my order book.
It seems simple but I'm stuck...
Thank you for your help.
I am using Excel 2010 and I am looking for a formula that allows me,
based on an existing "X" table located in sheet 1 (Example: Column A = Order No, Column B = Order Date, Column C = Delivery Date) ,
to automatically fill another "Y" table in sheet 2 (Example: Column A = Order No, Column B = Delivery Date) only with the rows from the X table where the "Delivery Date" fields are filled in column C.
Basically, I am currently manually filling in 2 tables, the first one being an order book and the second one a delivery book, and I realize that a lot of data is common, so I am looking for that elusive formula that will allow me to populate the rows of my delivery book automatically when a date is entered in my order book.
It seems simple but I'm stuck...
Thank you for your help.
3 réponses
Good evening,
Have you tried the Excel function
VLOOKUP
it searches for a value in the first column of a table and then returns the value of a cell that is located on the same row as the searched value.
Usage:
=VLOOKUP(lookup_value; table_array; col_index_num; range_lookup)
Best regards
Happiness is like health, you only notice it when it disappears.
Have you tried the Excel function
VLOOKUP
it searches for a value in the first column of a table and then returns the value of a cell that is located on the same row as the searched value.
Usage:
=VLOOKUP(lookup_value; table_array; col_index_num; range_lookup)
Best regards
Happiness is like health, you only notice it when it disappears.
Can you upload a part of your file on cjoint.com and include the link obtained in your next message? Don't forget to add explanations and examples of the expected result
1) Go to https://www.cjoint.com/
2) Click on [Browse] to select your file
3) Scroll down to the bottom of the page to click on [Create Cjoint link]
4) After a few seconds, the second page will appear, with the link
in blue underlined; select it and click "Copy"
5) Return to the discussion on CCM, and in your reply message
click "Paste"