Hello Friends,
I have two tables in one sheet. first table includes three columns and many rows and the second one also has some rows and columns.
In the second table headers are "Product Name", "Price 1" and "Price 2"
In first table I want to make a drop down list in first column of a row, in a way that I can choose between products from a drop down list which its source is "Product Name" column from second table.
What is important is when I choose for example "Product A" from drop down list, I want in the next cells the "Price 1" and "Price 2" of product A should be listed automatically! and so on, when I choose "Product B", "price 1" and "price 2" of "product B" should be listed automatically in next cells.
Thank you very much in advance
waiting for your urgent help
I have two tables in one sheet. first table includes three columns and many rows and the second one also has some rows and columns.
In the second table headers are "Product Name", "Price 1" and "Price 2"
In first table I want to make a drop down list in first column of a row, in a way that I can choose between products from a drop down list which its source is "Product Name" column from second table.
What is important is when I choose for example "Product A" from drop down list, I want in the next cells the "Price 1" and "Price 2" of product A should be listed automatically! and so on, when I choose "Product B", "price 1" and "price 2" of "product B" should be listed automatically in next cells.
Thank you very much in advance
waiting for your urgent help
