Vlookup Help!

[Matalyn]

I need to pull data from one sheet and put it into another automatically.

My home sheet has the following data...
Column A: % of project completed
Column B: Status of project (either in progress, on hold, or completed)
Column C: Task Description
Column D: Date project was started
Column E: Date project is estimated to be completed
Column F: Actual Completion Date
Column G: Employee who is assigned the project
Each row is a different project

My goal here is:
If a project is assigned to a specific employee (i.e. Bob), then I want all of the above data in that row assigned to bob to be pulled from the home page and put into sheet 2. Sheet 2 has the same formatting as the home page.

Each time I add another project and assign it to bob, i want it to be automatically added to sheet 2.

Is this possible using the vlookup formula?

If so can you demonstrate?

Thanks

 

[DLB20720]

Matalyn, I would consider using INDEX / MATCH rather than vlookup. I am working on resolving a similar issue where I need to have a formula return multiple results based on 1 input criteria (Bob). I'm hoping someone on this board can help resolve my issue and you may want to follow that thread. Link here;

http://www.mrexcel.com/forum/excel-...ues-matching-unique-criteria.html#post3977655