INDIRECT ADDRESS #REF error

I have a spreadsheet where the beginning of the range can be in a different column each time. With the varying location, I thought INDIRECT, though volatile, would provide a solution, but the output is a #REF.

High level, I am looking to obtain every instance of Plan Name in row 4 (Apple, Banana, Kiwi) if the category row 3 = "Fruit". However, I want the range for the formula to begin where the word "Renewal" is located in row 1 (column H), which can be in a different location each time.

The formula that solves for find each instance:

Please Login or Register  to view this content.

However, with the changing location, I tried to use indirect for the index, but it provides a #REF:

Please Login or Register  to view this content.

The end of the index range will always be in the same spot ending in L4.

Open to any and all suggestions as I am baffled.

The nesting in single quotes was the issue - thank you!