values from "table" of numbers

U

unicorn

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: intel

Hi, I hope a simple answer is possible - i have a block/table of values 9x20, and want to access the info as a reference ie = value in cell that corresponds with value on horizontal & value on vertical. I've played with array/h&v lookup, cant work it out.
also can I use a dropdown to input data like a database ??
also is there full tutorial of excel features online somewhere?
 
J

JE McGimpsey

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: intel

Hi, I hope a simple answer is possible - i have a block/table of values 9x20,
and want to access the info as a reference ie = value in cell that
corresponds with value on horizontal & value on vertical. I've played with
array/h&v lookup, cant work it out.
Click to expand...

One way:

=INDEX(tbl, yval, xval)
also can I use a dropdown to input data like a database ??
Click to expand...

Not sure what you mean - "input like a database" could mean any of a
wide range of methods...

You can use a Data/Validation/List to choose an item from a dropdown
list. You could use Data/Form to enter records in a dialog.
also is there full tutorial of excel features online somewhere?
Click to expand...

There are far too many features for a "full tutorial". Help is once
again barely adequate, after having improved over the last several
versions. There are simple topics at Mactopia

http://www.microsoft.com/mac/help.mspx
 
U

unicorn

Hi, thanks for the advice, though that doesnt solve it

heres a sample, the result should read "93"
or "97" when values 30 & 40

orientatation 60 -Yvalues from other cellref
inclination 30 -Xvalues from other cellref
0 0 10 20 30 40
0 88 94 98 100 99
10 88 94 98 100 99
20 88 94 98 99 98
30 88 94 97 98 97
40 88 93 96 96 95
50 88 92 94 94 93
60 88 91 93 93 90
70 88 90 91 90 88
 
G

geboman

I think this is what you're looking for:
=INDEX($A$1:$F$9,MATCH(B14,$A$1:$A$9),MATCH(C14,$A$1:$F$1))

where A1:F9 represents the array you displayed below.
B14 are orientation values, and c14 are your inclination values.
 
Top