I am currently using an INDEX() function to do a basic data retrieval by
specifying both the collumn and rows.
INDEX(p1rn1,1,18)

p1rn1 is C2:AE28

the 1,18 retrieves what is in cell T3
in cell Q:S3 (Cells Q3 - S3 are merged) is the text string "Weap Dam Rec"

Is it possible to use INDEX(p1rn1,MATCH("Weap Dam Rec",?,?),?) to find the
data in T3, if so, what is the wording of the function? If INDEX() can't do
it, is there anyhting that can?

for the billionth time
Thanks
Adam