CODE function problem

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
 

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

Top