Select data from one sheet to another based on index field

dlafrankie

New Member
Joined
Dec 5, 2005
Messages
1
I have two spreadsheets. SHEET #1 is a table of information with approximately 400 rows and 10 columns (Lets call it THE DATABASE). The data is a listing of equipment numbers and specific associated equipment data on each row with the index being the equipment number in column A. The equipment numbers may or may not not be consecutive numbers and may not relate to the row number at all. I mean to say that equipment number 1 is not necessarily on row #1 in THE DATABASE.

My wish is to open Sheet #2 (Lets call it THE FORM) and enter an equipment number (index) in column A on any row and dynamically have the associated information for that equipment be filled into the same columns on THE FORM but be placed on the row in THE FORM where the Equipment number was entered. The data would be copied from THE DATABASE and placed into THE FORM on the row (in THE FORM) where I enter the EQUIPMENT number. I do not want to copy and paste. I want my entry of the equipment number into THE FORM bring the data from THE DATABASE and place into THE FORM on the row in the FORM where I enter the equipment number.

Your help is greatly appreciated. I hope I made this clear enough. If not please respond with further questions.

Thank You
Dave L
 

Excel Facts

Control Word Wrap
Press Alt+Enter to move to a new row in a cell. Lets you control where the words wrap.

NBVC

Well-known Member
Joined
Aug 31, 2005
Messages
5,828
I think you need Vlookup.

e.g.
In Sheet 2,if your Equip number is in A1, then in cell B1, enter

=Vlookup(A1,Sheet1!$A$1:$J$400,2,false), then copy formula to the right as far as needed to pull all necessary info from Sheet2. Then just change the "2", which is the column number where the info resides in Sheet1, to the next consecutive number.

Then copy all these formulas down as far as you want.

This assumes your table is in Sheet1, A1:J400. Change to suit, if necessary.
 
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,163,633
Messages
5,832,780
Members
430,167
Latest member
Gogogoben

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
Top