=IF(ISNA(VLOOKUP(A1,Sheet2!A1:C100,2,False),"",VLO OKUP(A1,Sheet2!A1:C100,2,F
alse))

will pull back the 2nd column from the lookup table, will do an exact match
on the lookup table if it is not in order (sometimes this may not be what is
required), and substitutes a blank if no match is found.


--
HTH

-------

Bob Phillips
"aducutlas " wrote in message
...
I'm trying to use the Vlookup function to pull data in from one
speadsheet into another.....but I have trouble using the function...Can
anyone assist.


---
Message posted from http://www.ExcelForum.com/