Is it possible to pull a whole row of values from sheet2 into sheet1? I wanted to do sheet1 column C will have a drop down list based on a data validation list in sheet2, and if the user selects a certain value from the list, it takes everything that is in that row in sheet2 and plug into sheet1. For example:
Sheet2, cell A1 will be apple, cell B1 will be orange, and C1 will be 100.
When the user is in sheet1 they will go to cell C1 and pick the value 100 from the drop down list and then cell A1 will pull the value apple and cell B1 will pull in the value orange.
Is this possible? The next step will be the next row in sheet2 will have different values but column C will go in sequence so C2 will be 200, C3 will be 300, and so forth. So I would want the user to be able to pick one of these numbers and based on whatever number they pick, it will take the values trailing it in the same row and plug that into sheet1.
Any help is appreciated. Thanks.
Sheet2, cell A1 will be apple, cell B1 will be orange, and C1 will be 100.
When the user is in sheet1 they will go to cell C1 and pick the value 100 from the drop down list and then cell A1 will pull the value apple and cell B1 will pull in the value orange.
Is this possible? The next step will be the next row in sheet2 will have different values but column C will go in sequence so C2 will be 200, C3 will be 300, and so forth. So I would want the user to be able to pick one of these numbers and based on whatever number they pick, it will take the values trailing it in the same row and plug that into sheet1.
Any help is appreciated. Thanks.