Hi,
I have two columns of data in excel. There is no common values between these two columns. Few values in column1 is mapped manually with values in column2. Now i need to display both columns with mapped and non mapped values. I attached a sample sheet with this.
Thanks
Regards,
Kannan S
In M18 Cell - Array Formula - Requires CTRL+SHIFT+ENTER
=IFERROR(INDEX($D$8:$D$17,MATCH(0,COUNTIF($M$8:M17,$D$8:$D$17),0)),"")
Array formulas need to be entered using the key combination of CTRL,SHIFT,ENTER (not just ENTER). Hold down both the CTRL key and the SHIFT key then hit ENTER.
Drag it down...
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
Thanks for your quick reply. I tried the formula u provided. But it didn't work for me.
I actually want a formula from field M8. Because aim is to display list 2 from the beginning if mapping is available, if not display the rest of the values.
If you have a formula for that, that would be great.
Thanks
In M8 Cell - Array Formula - Requires CTRL+SHIFT+ENTEROriginally Posted by kannan selvaraj
=IF(L8<>"",VLOOKUP(A8,$G$8:$H$17,2,FALSE),IFERROR(INDEX($D$8:$D$17,MATCH(0,COUNTIF($M$7:$M7,$D$8:$D$17),0)),""))
Drag it down...
Array formulas need to be entered using the key combination of CTRL,SHIFT,ENTER (not just ENTER). Hold down both the CTRL key and the SHIFT key then hit ENTER.
Wow. You are awesome. Thanks a lot for your help. It perfectly works for me.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks