I have been tasked with documenting a network, a fair sized network for my company. The network consists of at around 20 24-48 port switches, the majority of which have no open interfaces. In order to speed up my documentation process, I offloaded the mac address tables from my switches, and after cleaning them up a bit, set them up in a spreadsheet. From my dc and my wcs, I pulled my device lists and created a spreadsheet for them. Now, I have 2 spreadsheets. Sheet4 contains a list of mac addresses from my switches in Column B, and the corresponding interfaces in Column C. Sheet5 contains my device information, Dedicated Name in Column A, and the mac addresses which correspond to each dedicated name in Column B. I need to cross reference the two columns containing the mac address and when I find the cell with the matching mac address, I want to copy A & B from the row containing the match and insert that data into, let's say, column D and column E on the same row with the the switches mac and port. I can live without both values from Sheet5, if I can match the mac addresses (i.e...Match cell B2 to B99 (hypothetical), then Copy A99 (which would be the dedicated name for the mac address in cell B99) to Sheet4, D2 so that the row will now contain .... B2-MAC Address from Switch table, C2-Switch port ID, D2- Dedicated name of the connected device.