use a Named Range LastRow value instead of a hard coded Column and Row number question

[blbat]

I have a fully functional Named Range to find last row:

"LastRowSheet1"

(I know it works because I can enter =LastRowSheet1 in a cell and the correct row number is displayed)

I have an array formula that is fully functional as is:

=IFERROR(MATCH($A2&"|"$B2,Sheet1!$N$1:$N$300&"|"Sheet1!$O$1:$O$300,0)&" Keep this","Not Found")

C+S+E
(which returns the row number and text "Keep this" if Match is found)


Now I want to use the result of "LastRowSheet1" in the above formula.

What is the proper syntax to use if I want to switch out the value for $N$300 and $O$300 and use LastRowSheet1 ?

 

[Jeffrey Mahoney]

Please Try this

=IFERROR(MATCH($A2&"|"&$B2,Sheet1!$N$1:INDEX($N:$N,LastRowSheet1)&"|"&Sheet1!$O$1:INDEX($O:$O,LastRowSheet1),0)&" Keep this","Not Found")

 

[blbat]

Thanks Jeffrey,
I should have thought of the INDEX you threw in there, it just wasn't bubbling up in my thought process.
I appreciate the assist.

~blbat