Index Sequence Row formula using data from another cell as part of the formula

[AndyT410]

Hi,

I have a worksheet with an import of sales transactions. I'm using this formula to find all transactions within the last year.

=MAX(IF('Product Import'!$E:$E>='Product Bought'!$G$2,ROW('Product Import'!$E:$E)))

I want to use the result of that which is in cell B1 as part of the formula below to auto populate a column with everything from that row upwards. It works without using cell B1 in the formula but if I use cell B1 it only returns row 1.

Works

=INDEX('Product Import'!K:K,SEQUENCE(ROWS(1:2907)),1)

Result

Account Reference

01/8077

01/7822

01/7036

01/6668

01/6638

etc

Doesn't work

=INDEX('Product Import'!K:K,SEQUENCE(ROWS("1:"&B1)),1)

Result

Account Reference

Can anyone help?

[#2]

@AndyT410 

=INDEX('Product Import'!K:K,SEQUENCE(B1),1)

[#3 · Accepted solution]

Thanks Hans,
That worked. Thank you.