Looking for a formula
Hey there,
I did a survey and collected postal codes, and I want to match them up with the relevant city name.
On a separate sheet, in Column A I have the postal code data for my area, in Column B have I have the corresponding place names for each postal code.
I want to match up the postal codes from my survey data to my list on sheet 2. Could anyone suggest a formula for this.
Thanks for the help.
Posted Mar 22, 2019, 4:39 PM UTC
12
=VLOOKUP() is perfect for this. Assuming your sheets are called Sheet1 and Form Response with the postal code in column G of Form Response and you want the city name in H:
You can turn this into an arrayformula which extends through the entire column with
<3 thank you very much! Exactly what I needed!