Vlookup from Excel to Smartsheet

Jack C

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!

Alejandra

Hi Jack,

At this time, cross-sheet formulas only function within Smartsheet. There also isn't a way to bypass the 5,000 row limit. When you have a moment, please submit a Product Enhancement Request to let our Product team know that you'd like to have these functionalities in Smartsheet.