VLOOK UP

[Biruzz]

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.

 

[Nick Hodge]

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
(e-mail address removed)
www.nickhodge.co.uk