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.

Find more posts tagged with

IT & Operations

Comments

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

Sign in to join the conversation!

Quick Links

Trending discussions

HELP! Move Row Automation
I created a "move row to another sheet" automation where the trigger is when rows are changed and ACTIVE / INACTIVE status changes to INACTIVE. When I changed the status in one row, the automation was triggered and now all of my rows are gone, and they are not on the destination sheet either. Where is my data? There is no…
Published Sheet - Users Unable to add Attachments
I have a sheet for which I've provided a publish link to many unlicensed users. They use the sheet to attach files to rows. This has been working as expected for multiple years previously, but today, we've discovered it will not allow them to attach files to rows and they're met with the message "This action has been…
WorkApps Attachments Disabled
Has anyone seen this in WorkApps? Anyone know what's going on?