How to use Vlook up with end(xlup) ?

I have 30 tabs.
on first tab I have 29 rows with different values. I just need to use vlook function on 1st tab and look up values from each of the 29 tabs. In each of 29 worksheets, the table range shall be
calculated as follows. First I need to go to g10000 and then use ctrl up ( to get to last g filled cell) and then ctrl shift up.
How do I use this range in vlook up function. Please help

Please Login or Register  to view this content.

Administrative Note:

Welcome to the forum.

We would very much like to help you with your query, however you need to include code tags around your code.

Please take a moment to add the tags. Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, and it also maintains VBA formatting.

Please see Forum Rule #2 about code tags and adjust accordingly. Click on Edit to open your post, then highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here

(Note: this change is not optional. As you are new here, I have done it for you this time.)

Add a last row:

Please Login or Register  to view this content.

But is unclear to me if you want to use the last row in the Vlookup or to autofill the formula untill last row. If first, then use entire columns and there is no need to specify the last row

No: vloo = worksheetsfunction(vlookup(worksheets("sheet1").range("A1"), Range(Selection, Selection.End(xlUp).Offset(1, 0)).Select,1,2)

Please Login or Register  to view this content.