EXCEL table?

B

Beebs

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

Is it possible to create a table that I can populate with data and then when I type in a certain value into a worksheet , eg: a name; then the cell next to it will automatically fill with the value that I have assigned to that name in the table.
eg: Bill, 2
gail, 1.5
leslie, 3, etc

Many thanks in advance.

Beebs
 
B

Bob Greenblatt

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

Is it possible to create a table that I can populate with data and then when I
type in a certain value into a worksheet , eg: a name; then the cell next to
it will automatically fill with the value that I have assigned to that name in
the table.
eg: Bill, 2
gail, 1.5
leslie, 3, etc

Many thanks in advance.

Beebs
Click to expand...
Yes you can. But you have to understand that a formula can only change the
value of the cell it is in. It can not change the value of another cell. So,
you'll first have to set up your table somewhere on a worksheet. Then place
a hlookup formula (check excel help for details) in the cell(s) where you
want the lookup value to appear.
 
Top