Basic INDEX() question
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 |
Basic INDEX() question
Do you mean
=INDEX(p1rn1,1,18) -- HTH RP (remove nothere from the email address if mailing direct) "Adam Kroger @hotmail.com" <adam_kroger<nospam wrote in message ... 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 |
Basic INDEX() question
yep, thanks, that found the cell.
It was driving me flaming nuts. Excel's "help" files read like a foriegn language. Adam "Bob Phillips" wrote in message ... Do you mean =INDEX(p1rn1,1,18) -- HTH RP (remove nothere from the email address if mailing direct) "Adam Kroger @hotmail.com" <adam_kroger<nospam wrote in message ... 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 |
All times are GMT +1. The time now is 06:23 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com