Basic INDEX() question

A

Adam Kroger

I am trying to use INDEX() to look up specific cells on my worksheets. To
accomplish this I have a range named p1rn1 that refers to $C$3:$AE$22 I want
to refer to hex T3. What is the formula?
=INDEX(p1rn1,?,?)

Thanks
 
B

Bob Phillips

Do you mean

=INDEX(p1rn1,1,18)


--

HTH

RP
(remove nothere from the email address if mailing direct)
 
A

Adam Kroger

yep, thanks, that found the cell.
It was driving me flaming nuts. Excel's "help" files read like a foriegn
language.

Adam
 
Top