Find Table header in a dynamic range and start counting 1 cell below up to the last used range

[mabelO]

I have a function that returns a location of a header in a column (B)
It prints this location (B19) into cell A2
Below this header that is in B19 is a list of employees that i want to count up to the last used row

So i am looking for a way for excel to take a look at cell A2, grab the value in A2 which is another cell location (B19) and start counting from 1 cell below (B20) all the way to the last used row in column B.

The reason for the cell location been Printed in A2 is because the table is dynamic, i don't always know where the header will start from based on other information on the table so i have to first find the header and start counting 1 cell below it all the way to the last used row.

Attached is an example of what i'm looking for

 

[Fluff]

How about

=LOOKUP(2,1/(B1:B1000<>""),ROW(B1:B1000))-MATCH("List of Employees",B1:B1000,0)

 

[mabelO]

Omg, thanks a bunch!! that worked like a charm.

 

[Fluff]

You're welcome & thanks for the feedback.

 

[mabelO]

Hey, i was wondering if there is a way to determine the range of table 1 and select the range...

See table 2 starts one cell after table one ends. both Tables are dynamic so i cant always tell how big it will get. I know table 1 will always start at A5 but i dont know where it will end. I want to be able to select the whole range of table 1. I have attached a small visual to explain what i need.

 

[Fluff]

As that is a totally different question it needs a new thread. Thanks

 

[mabelO]

Ahh understood