Finding Data that match in two different sheets or list

[ash1279]

Dear All,

I'm a beginner in excel and I'm seeking for some help.
I have a list of about 1000 MAC Address which are connected to different locations and ports.
In sheet 1 I have all the MAC address but I don't know to which location and port the MAC Address are connected.
I have another sheet with the location name in which there is the MAC address and the port.
I want to update the Subscriber sheet where i have all the MAC Address and add 2 columns (in red on the sheet) with the location and the port as I have the contacts details in it.
I just want to compare Subscriber sheet with the other with location names, for example when i will select an area from another sheet it will show me only the MAC address and contact details for this area in the subscriber sheet so that i can update the 2 blank columns.
If there is a formula which can update the blank column, it will be better. Maybe i need to add a column for location in the location sheets so as it is easier to export from them.

What is the best way to work around with this?

You will notice that in sheet with name South the MAC are not in order and in sheet name Centre i have duplicates from other areas too but you will see the connected port is 0 which means it is not connected and has been moved to other location, same for sheet name north.


Thanks in advance for ur help, I have uploaded a simplified example of the sheet i am working on