Hi All
I need help. How should i compare value from 2 column and copy value from another column to new column.
For example.
excel forum.PNG
Okay so now, i need to compare value between Column A and Column D. If the ID match, i will need to copy value from Column B to Coumn E.
I tried to use =INDEX(B2:B5,MATCH(D2,A2:A5,1)) but i receive #N/A
Kindly advice
Bookmarks