compare and merge duplicates

[Guest]

I'm network techician and can retrieve information like mac-address and IP
from one source, cut and paste to a text file and import to excel. I have
another source to retreive machine names with mac-address, and another source
with mac-address and port number. I like to create one work sheet with this
information.

columns would be label mac,Ip,name,port.

 

[Guest]

So, mac address is your comon denominator.

I would use one of the copied sheets, say, mac-address and IP.
Assuming mac address is column A, IP is column B

Then, let's assume the mac-address and mac name are in columns A and B. and
the name of this sheet is mac name You would type in column C of your IP
sheet:
=vlookup(A2,'mac name'!A:B,2,FALSE)
This will bring the mac name over to the IP sheet.

same formula for the port number, but change to, say,
=vlookup(A2,'port number'!A:B,2,FALSE)

That what you wanted?

By the way, if the mac name does not appear on the other sheets, will return
an N/A...

 

[Guest]

Thanks, the port number works

So, mac address is your comon denominator.

I would use one of the copied sheets, say, mac-address and IP.
Assuming mac address is column A, IP is column B

Then, let's assume the mac-address and mac name are in columns A and B. and
the name of this sheet is mac name You would type in column C of your IP
sheet:
=vlookup(A2,'mac name'!A:B,2,FALSE)
This will bring the mac name over to the IP sheet.

same formula for the port number, but change to, say,
=vlookup(A2,'port number'!A:B,2,FALSE)

That what you wanted?

By the way, if the mac name does not appear on the other sheets, will return
an N/A...