VLOOKUP # of Row/Range

Jodi Mackie

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.

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.

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.

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. 👍️