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.

Answers

  • Mark Rojas
    Mark Rojas ✭✭✭✭

    @lclarkNE

    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

    ~MR