VLOOK UP
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. |
VLOOK UP
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. |
All times are GMT +1. The time now is 03:47 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com