Gsheets Unique Formula

[yessir]

Hello,

I currently have over 300 address in column "A" and was wondering if there was a way to populate the county the addresses are located in within column "B" using a formula. Any insight?

Address

Formula to display column

 

[ExceLoki]

how are the addresses formatted? can you share some examples?

 

[yessir]

Currently formatted below

1066 Marina Blvd, San Leandro, CA 94577

1050 Capitol Expressway Auto Mall, San Jose, CA 95136

6700 Automall Pkwy, Gilroy, CA 95020

5590 N Blackstone Ave, Fresno, CA 93710

200 N Sunrise Ave, Roseville, CA 95661

 

[ExceLoki]

do you have a list of the counties with the associated zip codes? if so you could do a match using that

 

[yessir]

I don't have a list of counties. I only have full address and zip codes

 

[yessir]

Can gsheets convert Zip code to county?

 

[ExceLoki]

if you have a list of zip code and the corresponding counties on another sheet, then yes it could. you would need to have that data to reference