I'm trying to sort multiple columns of contact information (home, cell, bus, other) phone numbers,
the issue is that different types could be in different columns...so I'm trying to put all of the same type in the correct column..
I tried a VLookup
but that doesn't take into account if I have the type in a different set of columns...
Example spreadsheet attached..I have a feeling this can only be achieved through VBAforum.ozgrid.com/index.php?attachment/64427/