A
Art
I have a spreadsheet where I have Column values 0 (Zero) through F (B2:Q2)
and Row values 0 through F (A3:A18), which represent hex values when
combined. When I enter a 2-digit value on the first page of my spreadsheet in
cell C34, I want the function to go to the second page of my spreadsheet and
return the contents of the cell referenced by the [Column][Row] values of
that 2-digit number.
I've been given the following function, and it works fine on my desktop and
notebook; My problem is that it doesn't work on my PDA because Docs to Go
doesn't utilize the CODE function from Excel.
=INDEX('Tone Freq Assignments'!B3:Q18,
IF(CODE(RIGHT(C34,1))>CODE("9"),CODE(RIGHT(C34,1))-CODE("A")+11,RIGHT(C34,1)
+ 1),
IF(CODE(LEFT(C34,1))>CODE("9"),CODE(LEFT(C34,1))-CODE("A")+11,LEFT(C34,1) +
1))
Does anybody have an alternate way that Docs to Go will recognize?
Thanks,
Art
and Row values 0 through F (A3:A18), which represent hex values when
combined. When I enter a 2-digit value on the first page of my spreadsheet in
cell C34, I want the function to go to the second page of my spreadsheet and
return the contents of the cell referenced by the [Column][Row] values of
that 2-digit number.
I've been given the following function, and it works fine on my desktop and
notebook; My problem is that it doesn't work on my PDA because Docs to Go
doesn't utilize the CODE function from Excel.
=INDEX('Tone Freq Assignments'!B3:Q18,
IF(CODE(RIGHT(C34,1))>CODE("9"),CODE(RIGHT(C34,1))-CODE("A")+11,RIGHT(C34,1)
+ 1),
IF(CODE(LEFT(C34,1))>CODE("9"),CODE(LEFT(C34,1))-CODE("A")+11,LEFT(C34,1) +
1))
Does anybody have an alternate way that Docs to Go will recognize?
Thanks,
Art