Linking data from various worksheets
 

I have a master worksheet and column A contains a unique value for each
record. I need to be able to pick up values from other workbooks provided
there is an entry in the worksheet for the same unique value. For example A1
in worksheet 1 is 12345 and A1 in worksheet 2 is 12345 and I need to pick up
the entry from worksheet 2 column H (8).

I can do a VLOOKUP and confirm the there is a corresponding value in
worksheet 2 column 1 but how do I get the data item from worksheet 2 column 8?

Many thanks in advance

Linking data from various worksheets
 

Hi,

I'm confused, are you trying to do a lookup in another workbook or worksheet?

for another workbook try:
=VLOOKUP(A1,[Book2]Sheet1!$A$1:$H$10,8,FALSE)

for another worksheet in the same book try:-
=VLOOKUP(Sheet2!$A$1:$H$10,8,FALSE)

Mike

"Mick Seamarks" wrote:

I have a master worksheet and column A contains a unique value for each
record. I need to be able to pick up values from other workbooks provided
there is an entry in the worksheet for the same unique value. For example A1
in worksheet 1 is 12345 and A1 in worksheet 2 is 12345 and I need to pick up
the entry from worksheet 2 column H (8).

I can do a VLOOKUP and confirm the there is a corresponding value in
worksheet 2 column 1 but how do I get the data item from worksheet 2 column 8?

Many thanks in advance

Linking data from various worksheets
 

Mike,

Sorry to be vague, it is another worksheet.

The unique values are in column A in both worksheets and I need to pick up
the value from column H in the second worksheet and place it into the first
worksheet. Not all the records are in the 2nd spreadsheets (1362 in first,
1100 in second) so i cannot simply do a direct link.

Tried the suggestion, but all rows return #Value!

"Mike H" wrote:

Hi,

I'm confused, are you trying to do a lookup in another workbook or worksheet?

for another workbook try:
=VLOOKUP(A1,[Book2]Sheet1!$A$1:$H$10,8,FALSE)

for another worksheet in the same book try:-
=VLOOKUP(Sheet2!$A$1:$H$10,8,FALSE)

Mike

"Mick Seamarks" wrote:

I have a master worksheet and column A contains a unique value for each
record. I need to be able to pick up values from other workbooks provided
there is an entry in the worksheet for the same unique value. For example A1
in worksheet 1 is 12345 and A1 in worksheet 2 is 12345 and I need to pick up
the entry from worksheet 2 column H (8).

I can do a VLOOKUP and confirm the there is a corresponding value in
worksheet 2 column 1 but how do I get the data item from worksheet 2 column 8?

Many thanks in advance

Linking data from various worksheets
 

What is your current formula that you made?

--
A.B.


"Mick Seamarks" rakstîja:

I have a master worksheet and column A contains a unique value for each
record. I need to be able to pick up values from other workbooks provided
there is an entry in the worksheet for the same unique value. For example A1
in worksheet 1 is 12345 and A1 in worksheet 2 is 12345 and I need to pick up
the entry from worksheet 2 column H (8).

I can do a VLOOKUP and confirm the there is a corresponding value in
worksheet 2 column 1 but how do I get the data item from worksheet 2 column 8?

Many thanks in advance

Linking data from various worksheets
 

Mick,

I don't understand why the second formula doesn't work. Put this in sheet 1
and drag down, it will look for a match in column A of sheet 2 and return the
value in column 8 if a match is found.

=VLOOKUP(A1,Sheet2!A$1:H$10,8,FALSE)

Mike

"Mick Seamarks" wrote:

Mike,

Sorry to be vague, it is another worksheet.

The unique values are in column A in both worksheets and I need to pick up
the value from column H in the second worksheet and place it into the first
worksheet. Not all the records are in the 2nd spreadsheets (1362 in first,
1100 in second) so i cannot simply do a direct link.

Tried the suggestion, but all rows return #Value!

"Mike H" wrote:

Hi,

I'm confused, are you trying to do a lookup in another workbook or worksheet?

for another workbook try:
=VLOOKUP(A1,[Book2]Sheet1!$A$1:$H$10,8,FALSE)

for another worksheet in the same book try:-
=VLOOKUP(Sheet2!$A$1:$H$10,8,FALSE)

Mike

"Mick Seamarks" wrote:

I have a master worksheet and column A contains a unique value for each
record. I need to be able to pick up values from other workbooks provided
there is an entry in the worksheet for the same unique value. For example A1
in worksheet 1 is 12345 and A1 in worksheet 2 is 12345 and I need to pick up
the entry from worksheet 2 column H (8).

I can do a VLOOKUP and confirm the there is a corresponding value in
worksheet 2 column 1 but how do I get the data item from worksheet 2 column 8?

Many thanks in advance

Linking data from various worksheets
 

Mike had a small type; you need =VLOOKUP(A1, Sheet2!$A$1:$H$1100,8,FALSE)
Let us know if this works
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"Mick Seamarks" wrote in message
...
Mike,

Sorry to be vague, it is another worksheet.

The unique values are in column A in both worksheets and I need to pick up
the value from column H in the second worksheet and place it into the
first
worksheet. Not all the records are in the 2nd spreadsheets (1362 in
first,
1100 in second) so i cannot simply do a direct link.

Tried the suggestion, but all rows return #Value!

"Mike H" wrote:

Hi,

I'm confused, are you trying to do a lookup in another workbook or
worksheet?

for another workbook try:
=VLOOKUP(A1,[Book2]Sheet1!$A$1:$H$10,8,FALSE)

for another worksheet in the same book try:-
=VLOOKUP(Sheet2!$A$1:$H$10,8,FALSE)

Mike

"Mick Seamarks" wrote:

I have a master worksheet and column A contains a unique value for each
record. I need to be able to pick up values from other workbooks
provided
there is an entry in the worksheet for the same unique value. For
example A1
in worksheet 1 is 12345 and A1 in worksheet 2 is 12345 and I need to
pick up
the entry from worksheet 2 column H (8).

I can do a VLOOKUP and confirm the there is a corresponding value in
worksheet 2 column 1 but how do I get the data item from worksheet 2
column 8?

Many thanks in advance

Linking data from various worksheets
 

Sussed it out thanks, finger trouble this end! Cheers for the assistance
everyone

"Aivis" wrote:


What is your current formula that you made?

--
A.B.


"Mick Seamarks" rakstîja:

I have a master worksheet and column A contains a unique value for each
record. I need to be able to pick up values from other workbooks provided
there is an entry in the worksheet for the same unique value. For example A1
in worksheet 1 is 12345 and A1 in worksheet 2 is 12345 and I need to pick up
the entry from worksheet 2 column H (8).

I can do a VLOOKUP and confirm the there is a corresponding value in
worksheet 2 column 1 but how do I get the data item from worksheet 2 column 8?

Many thanks in advance

Linking data from various worksheets
 

Mick,
When you are in your second worksheet that you are filling info in to from
the master page. Click the cell you want the information to go to. Then
click the function button(the fx in front of the address bar) you can select
what type of data it should be. Then go to you master sheet and click the
cell that you want to fill in.
Click enter and the info should be shared. Save this work sheet if you want
to keep this as a templet for later.
--
April


"Mick Seamarks" wrote:

I have a master worksheet and column A contains a unique value for each
record. I need to be able to pick up values from other workbooks provided
there is an entry in the worksheet for the same unique value. For example A1
in worksheet 1 is 12345 and A1 in worksheet 2 is 12345 and I need to pick up
the entry from worksheet 2 column H (8).

I can do a VLOOKUP and confirm the there is a corresponding value in
worksheet 2 column 1 but how do I get the data item from worksheet 2 column 8?

Many thanks in advance