Pulling info from master sheet to sheet 2 based on ID number input

**GSI2013** · 01-23-2013, 08:23 PM

First time in a forum and first time posting anything so please be gentle and pardon my ignorance

So I have a master sheet with text, drop down menus, numbers, dates, etc...
On sheet two I would like to make a simple table that would import specific parts from the master sheet based upon a shared ID#.
I'll break it down....
Master Sheet (sheet 1):
The information I would like pulled from the master sheet are two columns: Project (E) and Manager (F)
The identifying column that would be shared between the two sheets are ID# which is column C in the master.
Data doesn't begin in the master sheet until row four.
Sheet 2:
The new sheet is going to have other stuff on it but what I want to do is start it off with the first column being the ID#(A), then Project (B), Manager (C), then other junk I haven't even begin to dream up yet. Information will start on row two.
Goal:
I'd like to get a formula set up for sheet 2 to read what number I input into column A. To keep it easy, we'll just say 1.
I then want the formula to read that 1, reference it to the 1 in the master sheet, pull the text from the same row, and input that text to sheet 2.
So on sheet 2, A2 will be blank but I'll put in a number. The formula should kick in, match that 1 to the 1 on the master which is at A4. Then (still in master) it will copy that text from E4 and F4 and input that text automatically into (back to sheet2) B2 and C2 respectively.
I have a knack for taking something very simple and explaining it in the worst way possible so I apologize if I did that. The workbook is confidential or else I'd post it here.
I can't thank you all enough in advance for the help and I look forward to hearing back!

**Moo the Dog** · 01-23-2013, 08:31 PM

try this in cell B2 on sheet2 (assuming your master sheet is named "Master Sheet" without the quotes) adjust the range up to or beyond row 100 as you need:
=VLOOKUP($A2,'Master Sheet'!$C$4:$F$100,3,0)

and this in C2, same assumptions:
=VLOOKUP($A2,'Master Sheet'!$C$4:$F$100,4,0)

- Moo

**Pete_UK** · 01-23-2013, 08:32 PM

Put this formula in B2 of Sheet2:

Formula:

Please Login or Register  to view this content.

and put this formula in C2 of Sheet2:

Formula:

Please Login or Register  to view this content.

The cells will appear blank, but if you put a number in A2 (which has a matching ID number on the Master sheet), then the corresponding text will appear in those two cells. You can then put a different number into A2 and the text will change as appropriate, or if you want to enter a few different numbers, then the formulae in B2 and C2 can be copied down their columns and you can put different numbers into column A to retrieve the appropriate data.

Hope this helps.

Pete