Basic INDEX() question

  • Thread starter Thread starter Adam Kroger
  • Start date Start date
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
 
Do you mean

=INDEX(p1rn1,1,18)


--

HTH

RP
(remove nothere from the email address if mailing direct)
 
yep, thanks, that found the cell.
It was driving me flaming nuts. Excel's "help" files read like a foriegn
language.

Adam
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Basic INDEX(MATCH()) Question: 6
Passing a range name as an argument to the Index Function 2
refer to range in another sheet 5
Using INDIRECT Function and INDEX Function 1
Index/Match vs VLookup? 4
VLOOKUP Column Index 5
Using Index, Match and Search to populate items to a calendar view 2
format indexed cell 1

Back
Top