Sort-Lookup multiple cells

  • Hello!

    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 I'm trying to put all of the same type in the correct column..

    see example,

    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

    many thanks!

  • Re: Sort-Lookup multiple cells


  • Re: Sort-Lookup multiple cells

    This is great!

    thank you!

    Quote from jindon;740947


Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!