How do I lookup a single cell value from aworksheet (source sheet) and have the value appearanother

[TAL]

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

I'm working on our personal finances and have created worksheets per fiscal year (Apr '04-'05, Apr '05-'06, etc.). I want to chart our results on a summary worksheet which takes the values from the yearly worksheets. How do I get the value to appear from one cell of yearly worksheet (i.e. my gross salary) onto the summary worksheet so that the salary from multiple years can appear in one row. I'd like it so that if I change my data on the yearly worksheet (i.e. Apr '08-'09), the change is reflected automatically on the summary worksheet which I'm using as a data table for charts.

I tried the following but got an error. Your help would be appreciated.
=VLOOKUP('Apr ''04-''05'!G2)

 

[Bob Greenblatt]

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

I'm working on our personal finances and have created worksheets per fiscal
year (Apr '04-'05, Apr '05-'06, etc.). I want to chart our results on a
summary worksheet which takes the values from the yearly worksheets. How do I
get the value to appear from one cell of yearly worksheet (i.e. my gross
salary) onto the summary worksheet so that the salary from multiple years can
appear in one row. I'd like it so that if I change my data on the yearly
worksheet (i.e. Apr '08-'09), the change is reflected automatically on the
summary worksheet which I'm using as a data table for charts.

I tried the following but got an error. Your help would be appreciated.
=VLOOKUP('Apr ''04-''05'!G2)

Sounds like you just want a simple link. In the summary worksheet, in the
cell where you want a number, type an equal sign "=". Then switch to the
yearly sheet and click in the cell whose data you want to appear in the
summary sheet. Then press Return.

 

[TAL]

Exactly what I was looking for. Thank you!