r/sheets•
Mooshify

Looking for a formula

Solved

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
dralkyr•

=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:

=VLOOKUP(G2,Sheet1!A:B,2,0)

You can turn this into an arrayformula which extends through the entire column with

=ARRAYFORMULA(IF(LEN(G2:G),VLOOKUP(G2:G,Sheet1!A:B,2,0),))

​

1
MooshifyOP•

<3 thank you very much! Exactly what I needed!

1