INDEX Function

  • Thread starter Thread starter Jerzy
  • Start date Start date
J

Jerzy

Hello to all,

I need to find an alternative to the "INDIRECT(A1)"
function. Indirect works well enough on my PC, but that
function is not supported in the "Documents to Go" program
that I use to work with Excel files on my Palm M515.

Here is what I really need: an elegant solution to a three
dimensional problem. I have 14 table that contain data
for "runway length required for takeoff". Each table is
based on airport elevation. In that table the Y is the
weight of the jet and the X is the temperature of the
atmosphere. For humans to find the correct "elevation"
(MSL) is easy, keep flipping pages till you get to the
page/table that you want. Now how do I teach Excel to do
this simple trick?

Using the INDEX and INDIRECT function:

INDEX(INDIRECT(A1),VLOOKUP(X,Y,Z),HLOOKUP(X,Y,Z))

I can get my PC to do what I need. But INDIRECT is not
supported in the program "Documents to Go".

Does anyone have another work-around solution that might
work? Thanks in advance for your time.
 
I do not know what functionthe "Docs to go" program has, but here are two
possibilities
- Use the CHOOSE function instead of INDIRECT
- use 14 INDEX statements in 14 different cells, with another Lookup in a
separate cell to decide which one to use.

hth
Charles
______________________
Decision Models
The Excel Calculation Site
www.DecisionModels.com
 
Back
Top