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
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)
"Adam Kroger @hotmail.com>" <adam_kroger<nospam> wrote in message
news:[email protected]...
> 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
>
>
>
yep, thanks, that found the cell.
It was driving me flaming nuts. Excel's "help" files read like a foriegn
language.
Adam
"Bob Phillips" <[email protected]> wrote in message
news:%[email protected]...
> 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
> news:[email protected]...
>> 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
>>
>>
>>
>
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks