Hello Ker,
Thank you very much for the reply,
Column B is the master Data column, Column C is the sub columns. All the
data from Column C exists in B and only once.
So when there is a match for any entry of C in Column B, then the
corresponding value of D should be copied to a new COlumn E and use the same
row as B
The excel sheet i have is like this
Ip-address | MAC-address | Mac-address | port address
So the columns Ip address and mac -address are related and the column
mac-address and port-address are related.
i want to combine the 2 mac-address column into 1 master column with the
correct ip address , mac-address and port address. For data that doesnt
match it should give NA in the port address field.
Hope this helps,
Once again Thanks a lot for replying