Tag Archives: Excel

Convert MAC Addresses in Excel

Posted on 10 August 2017 by matthannan

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 in a standard format.… Read the rest

Posted in Geek | Tagged , | Leave a comment

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

Posted on 2 January 2015 by matthannan

=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.… Read the rest

Posted in Geek | Tagged | 3 Comments