Forum Discussion

emilio esquivel's avatar
emilio esquivel
Copper Contributor
Mar 28, 2018

Sort by zip code

I am beyond clueless, sorry. I have a list that has 3 catagories, City, County, and Zip Code and I need to be able to put in a zip code and have all with corresponding zip code come to top of list. 

Formulas & Functions
Need Help
  • Jamil's avatar
    Jamil
    Bronze Contributor
    Mar 28, 2018

    Please see attached workbook.

     

    when you put a zipcode in A2 it will automatically return multiple value related to that zipcode.

     

    Formula in B2  copied down

    =IFERROR(INDEX($G$2:$G$11,SMALL(INDEX(($F$2:$F$11=$A$2)*(MATCH(ROW($G$2:$G$11),ROW($G$2:$G$11)))+($F$2:$F$11<>$A$2)*1048577,0,0),ROW(A1))),"")

     

    Formula in C2 copied down

    =IFERROR(INDEX($H$2:$H$11,SMALL(INDEX(($F$2:$F$11=$A$2)*(MATCH(ROW($H$2:$H$11),ROW($H$2:$H$11)))+($F$2:$F$11<>$A$2)*1048577,0,0),ROW(A1))),"")

     

Resources