Place range that stop at certain row

[Tony O’Brien]

Hi Chandoo
I have a indirect formula that works in getting the start of a table 1 but haven’t being able to stop at end of table 1.
The formula =INDIRECT(CV4&CV8)
CV4 = AL
CV8 = 13
Mean the start of the table.

Below is the formula tried
The range table formula =INDIRECT(“AL”&CV20&”:AL”&BT13)
AL = Column reference
CV20 = AL30 Start of table 1
AL = Column reference
BT13 = AL47 End of table 1

The table is 24 rows down as standard, but table varies in row number.
My question is how to place BT13 in the range of ? =INDIRECT(“AL”&CV20&”:AL”&BT13)
> I’ve tried as the less than sign fo BT13 meaning AL47

Regards

Tony

 

[Chihiro]

I'd recommend uploading sample workbook that clearly demonstrate your issue and what your end goal is.
We may not have exact solution to your issue, but some of us may have alternate solution.