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


    see example,


    I tried a VLookup

    Code
    =IF(ISERROR(VLOOKUP("HOME",$A2:$C2,2,FALSE)),"",VLOOKUP("HOME",$A2:$C2,2,FALSE))


    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/



    many thanks!

  • Re: Sort-Lookup multiple cells


    Try

  • Re: Sort-Lookup multiple cells


    This is great!


    thank you!


    Quote from jindon;740947

    Try

Participate now!

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