Dear all,
I have 2 excel workbooks, one(EXCEL-1) with 4 column entries and another(EXCEL-2) with 5 column entries(4 of which are same as EXCEL-1, with some entries missing). I want to copy extra 1 column(i.e., fifth column) from EXCEL-2 to EXCEL-1 wherever the 1st 4 column entries of EXCEL-1 are matching with respective entries of EXCEL-2. Please help me on how to do it.
Thank you.
Hi ShreyJain,
Welcome to the forum.
You can achieve this using Index - Match array function.. upload the sample workbook and I'll show you how to achieve this. Thanks.
Regards,
DILIPandey
<click on below 'star' if this helps>
DILIPandey, Excel rMVP
+919810929744 (India), +971528225509 (Dubai), [email protected]
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks