Workbook Formulas

K

KLW

I hope I explain this right! I need to create a master worksheet in a
workbook that has several columns related to different descriptors of
projects. Each project description takes up a row and about ten different
columns with field information containing due dates, description of project,
project manager, etc. The first column would ideally be filled in with key
words, letters or numbers that corresponded to a different project type
(environmental, water, contaminated sites, etc) so that in the other
worksheets, if the numbers/letters in the master worksheet applied to those
different worksheets (each one a different type of project), the information
in the entire row would automatically transfer over to the worksheets each
row correlated with. So if you entered information into the master worksheet
and the project dealt with three different project types, all of the
information would transfer into the three worksheets according to type???
 
J

Jacob Skaria

In sheet2 and subsequent sheets try VLOOKUP...

--MAster sheet contains the key number in ColA and info....in subsequent
columns
--Sheet2 Col A contain the key number

Enter the below formula in Sheet2 B2; will return the second column
information...
=VLOOKUP(A2,Master!A1:J100,2,FALSE)

The below will return the 3rd row info
=VLOOKUP(A2,Master!A1:J100,3,FALSE)

If this post helps click Yes
 
J

Jacob Skaria

In sheet2 and subsequent sheets try VLOOKUP...

--MAster sheet contains the key number in ColA and info....in subsequent
columns
--Sheet2 Col A contain the key number

Enter the below formula in Sheet2 B2; will return the second column
information...
=VLOOKUP(A2,Master!A1:J100,2,FALSE)

The below will return the 3rd row info
=VLOOKUP(A2,Master!A1:J100,3,FALSE)

If this post helps click Yes
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top