Tag Archives: Excel

Convert MAC Addresses in Excel

I have 140 MAC addresses that I need to find out not only what switch, and switch port they are on, but also which part of the floor. It is a time-consuming slog, especially since the MAC addresses are not … Continue reading

Posted in Geek | Tagged , | Leave a comment

Say Goodbye to VLOOKUP, and Hello to INDEX-MATCH | eImagine Technology Group

=INDEX(nodes.csv!$A$1:$A$31,MATCH(C2,nodes.csv!$B$1:$B$31,0)) Say Goodbye to VLOOKUP, and Hello to INDEX-MATCH | eImagine Technology Group.

Posted in Geek | Tagged | 3 Comments