Vlookup from Excel to Smartsheet

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!