googlesheet get last non blank row from specific rows

By Following code in google spreadsheet I select last not empty row (based on data in H column and get data from cell "O").

=INDEX(O:O,MAX(IF( H:H<>"",ROW(H:H),0)))

It work properly. Now, I want to add condition to that search so it check only specific rows. ( Rows with specific amount in A column, so I need to add A:A="string" condition to that formula) how can I do that?

>Solution :

You may try:

=index(O:O,max(if((H:H<>"")*(A:A="String"),row(H:H),0)))

OR

=chooserows(filter(O:O,H:H<>"",A:A="String"),-1)