Vlookup limitation of 25000 cells

anilkrag1984

Can anyone help me to rectify the error as I am using cross sheet vlookup function in Smartsheet to extract some information, while doing this I am facing the error that we can only reference a total of 25000 cells. Is there any way If we want to update multiple columns with the help of other sheet just to avoid the manual updation.

Andrée Starå

Hi,

Depending on your need you could change the VLOOKUP to an INDEX/MATCH combination instead that possibly wouldn't require as many references.

Would that work?

Have a fantastic day!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting