Vlook Up Formula

[Toya Mack]

Hello, I am knew to the thread and requesting any possible assistance on a formula.

I have a workbook that has 15 worksheets. The first worksheet contains information contracts with that I have to manually input on the applicable worksheets-based on their project. I would like to use a formula on the other worksheets that once I paste the information on the first worksheet they will auto populate on the other worksheets based on the project they are in. but instead of the information going on the next available cell its not???

 

[Menumorut]

Hi,

If your register is column based maybe you can create a template with vlookup, looking up a specific name for each project/line.
Then on the file you want the values simply put the value you want to look up (project name?).

I hope this makes sens, I used this to avoid working twice on stuff like this but you must make sure you information will always be in the same columns.

Cheers,
Emil