Hi!

INDEX(p1rn1,1,18)

p1rn1 is C2:AE28

the 1,18 retrieves what is in cell T3

Are you sure about that?

If the named range starts in row 2 (C2), then maybe this will return the
value in T3:

=INDEX(P1M1,2,18)

Either that or the named range is really C3:AE28 or maybe you meant T2?

So, is "Weap Dam Rec" in the first row of the named range?

You could use something like this:

=INDEX(P1M1,1,MATCH("weap dam rec",INDEX(P1M1,1,),0)+3)

But why use something like that if this works:

=INDEX(P1M1,1,18)

Biff

"Adam Kroger @hotmail.com" <adam_kroger<nospam wrote in message
. ..
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