Lookup and Populate
 

I have a masterfile worksheet that has all the names and catergories listed
in rows/columns.
I have worksheets that have the same information but in column G the
information is populated with the information I want.

What formula/macro can I use to make it so that the information is matched
in columns a-F exactly (numbers and letters) and then the worksheet with
column G populated is populated in the master worksheet. The worksheets are
in several different spreadsheets.

Below is an example:

Column A Column B Column C Columnnd D Column E Column F Column G
Row 1
Row 2
Row 3
Row 4...

Lookup and Populate
 

Which function do I put in which worksheet?
How can I make sure that it checks all the rows for a match? There maybe a
match between the 2 set of worksheets but in different rows.

Thanks

"Knox" wrote:

write an array if statement something like this referencing your master to
the others:

{=IF(A11:F11=A12:F12,G11:G11,"")}

be sure to hit ctrl+shift+enter after typing the formula

{=IF('master'A11:F11=A12:F12,'master'G11:G11,"")}

"NeedExcelHelp07" wrote:

I have a masterfile worksheet that has all the names and catergories listed
in rows/columns.
I have worksheets that have the same information but in column G the
information is populated with the information I want.

What formula/macro can I use to make it so that the information is matched
in columns a-F exactly (numbers and letters) and then the worksheet with
column G populated is populated in the master worksheet. The worksheets are
in several different spreadsheets.

Below is an example:

Column A Column B Column C Columnnd D Column E Column F Column G
Row 1
Row 2
Row 3
Row 4...

Lookup and Populate
 

ok I got this formula to work but the problem is on the first string is
increasing when I fill the formula down to the other rows. How can I fill the
formula down while rows references increase by 1?

"NeedExcelHelp07" wrote:

Which function do I put in which worksheet?
How can I make sure that it checks all the rows for a match? There maybe a
match between the 2 set of worksheets but in different rows.

Thanks

"Knox" wrote:

write an array if statement something like this referencing your master to
the others:

{=IF(A11:F11=A12:F12,G11:G11,"")}

be sure to hit ctrl+shift+enter after typing the formula

{=IF('master'A11:F11=A12:F12,'master'G11:G11,"")}

"NeedExcelHelp07" wrote:

I have a masterfile worksheet that has all the names and catergories listed
in rows/columns.
I have worksheets that have the same information but in column G the
information is populated with the information I want.

What formula/macro can I use to make it so that the information is matched
in columns a-F exactly (numbers and letters) and then the worksheet with
column G populated is populated in the master worksheet. The worksheets are
in several different spreadsheets.

Below is an example:

Column A Column B Column C Columnnd D Column E Column F Column G
Row 1
Row 2
Row 3
Row 4...