Vlookup from Excel to Smartsheet

Jack C
Jack C
edited 12/09/19 in Formulas and Functions

My apologies if this has already been covered, but I didn't see anything specific to this subject when searching.

I have a Excel sheet that has 45,000 + rows. The data in the rows are filled by 2 columns - United States Zip Code's and city's linked to those zip codes. This Excel sheet is used as a vlookup for multiple other Excel sheets with one specific that I need to move to Smartsheets. With the limitations of 5,000 rows in Smartsheets is there a way to use the vlookup function in Smartsheets from data on an Excel spreedsheet? Or is there anyway to expand on the limited 5000 rows in Smartsheets if only using 2 columns of data?

I hope this makes sense, please let me know if you need me to explain this in more detail. Thanks in advance for any help!


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!