Compare Non Exact value from 2column and copy value

[Noren Tumaisuri]

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

[KOKOSEK]

Put into E2:

Please Login or Register  to view this content.

and drag it down.

[Noren Tumaisuri]

Put into E2:

Please Login or Register  to view this content.

and drag it down.

Thank you so much ! you helped me to solve it!! BTW, what does this "*" mean?

[alansidman]

In Column G, I placed the following =MID(A2,4,4)*1 as a helper column
Then in Column D, I placed the following =INDEX($B$2:$B$5,MATCH(D2,$G$2:$G$5,0))

and copy down each.

[KOKOSEK]

BTW, what does this "*" mean?

It calls 'wildcards' * means any string like *celFor* for ExcelForum, because you got ID placed in the middle of string in col. A, you have to use that, but remember that KUL1234-David at this moment is the same as ABCE1234-Pamela because *1234* is the same for both of them.

You welcome.
If you happy with solution, please use thread tools and mark thread as SOLVED.

p.s and do not hesitate click * to add rep :-)