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.
Best Answer
-
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.
Answers
-
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.
-
Thank you, Paul. Problem solved. Not sure what went wrong when I originally tried it, but it worked now. Appreciate your help!
-
Happy to help. 👍️
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66K Get Help
- 429 Global Discussions
- 147 Industry Talk
- 487 Announcements
- 5.2K Ideas & Feature Requests
- 86 Brandfolder
- 152 Just for fun
- 74 Community Job Board
- 497 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!