Logo Questions Linux Laravel Mysql Ubuntu Git Menu
HTML CSS JAVASCRIPT SQL PYTHON PHP BOOTSTRAP JAVA JQUERY R React Kotlin
 

How can I find the state some zip code belongs to? [closed]

Tags:

excel

zipcode

I have about 30,000 zip codes, and I need to extract states. How can I achieve this?

like image 282
Buras Avatar asked Dec 27 '22 04:12

Buras

1 Answers

Copy this csv file from this website into your workbook and then use VLOOKUPto lookup the state from the zip code.

like image 96
frickskit Avatar answered Jan 08 '23 04:01

frickskit
Sign in to Comment

Related questions

Reading half million records from Excel workbook in a VSTO project
copy rows to a new worksheet VBA
Force Save As, MS Excel VBA
Calculate weekly and monthly total in spreadsheet
Vba macro to copy row from table if value in table meets condition
copy and paste formula with constant cell
How to add a new spreadsheet with VBA-Code, using VBA
Matching similar but not exact text strings in Excel VBA projects
How to write an ampersand to an XML file from an Excel file using VBA?
I am not able to clear and reset the background color of a Cell
Select non-blank rows in spreadsheet
Opening Excel sheet with full access in c#
Using VBA to put a chart series on the secondary X axis
Convert Multiple Rows into Single Stacked Column in Excel
Find Results in excel copy the rows to another sheet
Object variable or With block variable not set when returning from function
Is there a way to add vba macro code to excel?
Interop Excel not closing process
create Excel sheet between existing sheet using POI
Python - How can I install xlutils?

Donate For Us

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!