Lookup text over multi column and row array to return row number

Hi guys

Can't think how is best to tackle this one.

I've got a multi row and column array that I want to be able to find the lookup value in to return the row number or row result

I've popped a simple example in the attached workbook. Anyone able to help please? I've tried a lookup but I'm not quite getting there.

Thanks

fab, thankyou

I've had to do -19 at the end of my actual formula in the real data. I'm wondering what dictates what the final row deduction is as it's -2 in the mini example I did and -19 in my real workbook and I can't really tell how this number is being driven

Ah ok understood. That's because my actual table headings are on row 19