values from "table" of numbers

[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?

 

[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.

One way:

=INDEX(tbl, yval, xval)

also can I use a dropdown to input data like a database ??

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?

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

 

[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

 

[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.

 

[unicorn]

hiya, YES thanks that sorts that out perfectly, much appreciated