How to do a look up with matching value

lclarkNE

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

@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