Auto adjust row in formula

[excellicious]

Greetings-

I have a formula that works nicely below except I have to manually update the rows in order for the formula to work. The reference tab, which is the "FINAL REPORT', last row is not always 109. Once the data feed into the Final Report tab, the last row number varies from 108-150. How can adjust my formula to accommodate this function? Thank you in advance. Excellicious.

=INDEX('FINAL REPORT'!C:C,MATCH($A$3,'FINAL REPORT'!$A$2:$A$109,1)+MATCH($B3,INDIRECT(CONCATENATE("'FINAL REPORT'!B",MATCH($A$3,'FINAL REPORT'!$A$2:$A$109,0)+1,":B700")),0),1)

[yknet]

Hi,

If there are no more values beneath last row (109), it is better to select the whole column ($A:$A) for lookup_array. So that you don't need to change the reference.

Unfortunately, I've no idea, if there are data in the rest rows.

Hoping, it can help you!

[excellicious]

Thank you for your advice unfortunately it does not work.