(2) In the Output Values box, please specify the range you will place the returned state names (1) In the Lookup Values box, please specify zip codes that you will return state names based on In the LOOKUP between Two Values dialog, please configure as follows: Click Kutools > Super LOOKUP > LOOKUP between Two Values to enable the feature.Ģ. Full feature free trialģ0 days, no credit card required! Get It Nowġ. Please do as follows:ģ00 handy tools for Excel. Now, you can apply the LOOKUP between two values feature of Kutools for Excel to easily convert the zip codes to corresponding state names in bulk. Supposing you have added the zip codes table in your workbook, and you want to convert the zip codes in the G3:G11 to corresponding state names as below screenshot shown.
Kutools for Excel Solves Most of Your Problems, and Increases Your Productivity by