compare and merge duplicates

N

Net

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.
 
S

Sean Timmons

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...
 
N

Net

Thanks, the port number works

Sean Timmons said:
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...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top