VLOOKUP # of Row/Range

I created a cross-sheet VLOOKUP that will update status from one sheet to the next. The functionality works but the issue I cannot resolve is, on the reference sheet, I want the VLOOKUP to always review the first 500 rows of data.

I can't find where I'd be able to direct it to always review 500 rows. It seems to truncate down to the visible data and requires a manual reference update to include more.

How can I set it up to automatically review 500 rows or better yet, how can I set it up to dynamically adjust and review any and all lines with data in them?

Thank you for your help.

Find more posts tagged with

Formulas

Accepted answers

Paul Newcome

When you are setting up your cross sheet references, click on the column header(s) of the column(s) you want to reference. This will reference the entire column and will automatically take into account new rows as they are added.

All comments

Paul Newcome

Jodi Mackie

Thank you, Paul. Problem solved. Not sure what went wrong when I originally tried it, but it worked now. Appreciate your help!

Paul Newcome

Happy to help. 👍️

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.