Help me please - data validation for a row via dropdown in 1 cell
Hello, I am need of help with data validation for entire row. Task description: build a product selection spreadsheet that will input specific product values from a second sheet in the appropriate cells based on the product chosen from 1 cell.
The spreadsheet is attached for a better understanding, but basically the objective is as follow: from a secondary sheet (sheet 2) I would choose the Item Name and Code on the front sheet (sheet 1 cell B7 - merged with B8 and B9). On choosing the input via the validated dropdown cell (B7), the information on cells A7, C7, D7, E7, F7, G7, H7, I7, J7, K7, and L7 would automatic be populated from the information entered on the second sheet (sheet 2).
Very simple task, but I really don't know if this would be a table work or a data validation work and as well how to enter the formulation for it.
This would be repeated for the next rows below as well.
The spreadsheet is attached for a better understanding and the illustrated values are on the second sheet (sheet 2).
If someone can please take look and give the step by step here I will appreciate.
Thank you!
Mdfilho
| Attachment | Size |
|---|---|
| Tile Spreadsheet.xlsx | 76.44 KB |
you may use the VLOOKUP function
In your case I suggest to use the function "VLOOKUP" =VLOOKUP(lookup_value,table_array,col_index_num,range_lookup)
1. in sheet2 move the table of one column in a way that the title <
> is moved in cell "B1".
2. in the new column "A" put a progressive number from cell "A4" to "A21" from 1 to 18 (if you built a table of 18 row.
3. connect the control in cell "B11-B12-B13" to the cell "P11"
4. in cell "A11" put the formula <<=VLOOKUP(P11,Sheet2!A4:M21,2,FALSE)>>
5. in cell "B11" put the formula <<=VLOOKUP(P11,Sheet2!A4:M21,3,FALSE)>>
6. in cell "C11" put the formula <<=VLOOKUP(P11,Sheet2!A4:M21,4,FALSE)>>
7. in cell "D11" put the formula <<=VLOOKUP(P11,Sheet2!A4:M21,5,FALSE)>>
etc....
repeat the steps 3, 4, 5, 6, 7 ecc.. for each row in "sheet1"
Regards