Re: values from "table" of numbers
- From: JE McGimpsey <jemcgimpsey@xxxxxxxx>
- Date: Sat, 26 Apr 2008 06:17:09 -0600
In article <ee998b1.-1@xxxxxxxxxxxxxxxxxxxxxxx>,
unicorn@xxxxxxxxxxxxxxxx wrote:
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
.
- Follow-Ups:
- Re: values from "table" of numbers
- From: unicorn
- Re: values from "table" of numbers
- References:
- values from "table" of numbers
- From: unicorn
- values from "table" of numbers
- Prev by Date: Re: Retrieving damaged files
- Next by Date: Re: Recently Used File List not saving: sudden
- Previous by thread: values from "table" of numbers
- Next by thread: Re: values from "table" of numbers
- Index(es):
Relevant Pages
|
