What happens when you exceed a size limit in Google spreadsheet?

If you’re close to exceeding size limits, you’ll see a message at the top of your spreadsheet that indicates which limit you’re about to reach: Complexity: VLOOKUP and HLOOKUP formulas tend to be more complex than other functions, and may slow down your spreadsheet.
For More Information Please Refer:
https://docs.google.com/document/d/1E7sT_BMkFOXR4EsDMUUhOgeD6BrEjFzS8fHv8tNrfPU/edit#!
You May Also Like to Read:
How to import import data in Google Sheets?