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