Find duplicate values and then copy adjasent vale to empty cell

**dettrix** · 08-05-2012, 06:55 AM

Hi All

I have a formula problem : I need to find the duplicate value of column A (Serial Number) in column C (Serial Numbers) and then copy the value of the adjacent column D(Mac Address) value to Column B (Mac Address)

I have attached a example

Please Help.

Thanx

**Ace_XL** · 08-05-2012, 06:59 AM

Try in B2
=IFERROR(VLOOKUP(A2,$C$2:$D$7,2,FALSE),"")
and copy down

**dettrix** · 08-05-2012, 09:14 AM

Thank u
Thank U
Thank u

It works

**Cutter** · 08-05-2012, 09:26 AM

If you are satisfied with the solution(s) provided, please remember to mark your thread as Solved.

New quick method:
Select Thread Tools (above first post on page) -> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

Or you can use this way:
Go to the first post
Click edit
Click Go Advanced
Just below the word "Title" you will see a dropdown with the words "No prefix".
Change to "Solved"
Click Save