Biruzz
=IF(ISNA(VLOOKUP(A1,Sheet2!$A$1:$B$1000,2,FALSE)), "",VLOOKUP(A1,Sheet2!$A$1:$B$1000,2,FALSE))
This presumes the 2nd sheet is called Sheet2 and the range on that sheet
covers A1:B1000, change as necessary.
I have wrapped it in an ISNA function to return nothing if there is no match
--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
DTHIS
www.nickhodge.co.uk
"Biruzz" wrote in message
ups.com...
I have two sheets of data on a excel file. Both the sheets have almost
identical number of names in the A column. Sheet two has an additional
row of data that i need to paste in Sheet one if the names match.
Anybody know the formula.