Pull Row Of Values from Sheet2 Into Sheet1

data808

Active Member
Joined
Dec 3, 2010
Messages
358
Office Version
  1. 2019
Platform
  1. Windows
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.
 

Excel Facts

Who is Mr Spreadsheet?
Author John Walkenbach was Mr Spreadsheet until his retirement in June 2019.
Here's a couple of screenshots to help explain what I am talking about. So if the user selects 200 while being in Sheet1, I want it to pull in Banana and Grape into the row the user is selecting from the drop down list.
 

Attachments

  • Sheet1.PNG
    Sheet1.PNG
    49.8 KB · Views: 12
  • Sheet2.PNG
    Sheet2.PNG
    9.6 KB · Views: 11
Upvote 0

Forum statistics

Threads
1,223,230
Messages
6,170,883
Members
452,364
Latest member
springate

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top