Help with Lookup to find Last Row less a few rows

[Fletch74]

Hello All,

I'm using the formula =LOOKUP(10^99,INDEX($L$1:$N$1000,,MATCH($A3,$L$1:$N$1))) to obatin the last row in a Lookup, but how do I get it to show a specific row in a worksheet that changes the amount of rows I Lookup every month.

I have attached a sample of the sheet I am working with. I would like to reference the "SSM" row. Cell D1 shows the result I currently get and E1 is the result I want to get.

Cheers for the help :D

[6StringJazzer]

Try this:

=INDEX(INDEX($L$1:$N$1000,,MATCH($A3,$L$1:$N$1)),MATCH("SSM",$J:$J,0))

[Fletch74]

Legend 6SJ.

Knew it would probably come down to an INDEX/MATCH, but never thought of 2 INDEX/MATCH's

[6StringJazzer]

It had me going for a minute because I don't remember doing a double before. Thanks for the rep, and thanks for marking your thread Solved!