Forum Discussion
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.
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))),"")