How to do a look up with matching value


I am attempting to build out a list of zip codes with their matching counties. I'm not able to return the matching value back to the zip code listing.


  • Mark Rojas
    Mark Rojas ✭✭✭✭


    Try an INDEX(MATCH())

    I don't know exactly the structure of your data but the general flow would be =IFERROR(INDEX({the countries column},MATCH([Zip Code]@row, {Column of Zip Codes},0)),"")

    I add always add an IFERROR so I dont get a ton of #NO MATCH