Prev: Grouping dates on a Chart
Next: sum columns between certain dates
From: Ann on 29 Mar 2010 07:01
I have the name of a tab within a cell. How do I use this cell to look up
data on the tab.

Tab 1 has the following entry:-
Road 1

I wish to use this entry to go to the Road 1 tab and look up data held in
cell M6

Road 1 could then be updated to Road 2 and I then wish it to go to the Road
2 tab and display information from the same cell i.e. cell M6

Thank you
From: ozgrid.com on 29 Mar 2010 07:11
Try =INDIRECT("'"&A1&"'!M6")

Where A1 has the sheet tab name.


--
Regards
Dave Hawley
www.ozgrid.com
"Ann" <Ann(a)discussions.microsoft.com> wrote in message
news:1FD37AC6-FC95-49A4-9FDE-EC93F3C790EB(a)microsoft.com...
>I have the name of a tab within a cell. How do I use this cell to look up
> data on the tab.
>
> Tab 1 has the following entry:-
> Road 1
>
> I wish to use this entry to go to the Road 1 tab and look up data held in
> cell M6
>
> Road 1 could then be updated to Road 2 and I then wish it to go to the
> Road
> 2 tab and display information from the same cell i.e. cell M6
>
> Thank you

From: RonaldoOneNil on 29 Mar 2010 07:18
If your tab name is in A1 then use

=INDIRECT("'"&A1&"'!M6")

"Ann" wrote:

> I have the name of a tab within a cell. How do I use this cell to look up
> data on the tab.
>
> Tab 1 has the following entry:-
> Road 1
>
> I wish to use this entry to go to the Road 1 tab and look up data held in
> cell M6
>
> Road 1 could then be updated to Road 2 and I then wish it to go to the Road
> 2 tab and display information from the same cell i.e. cell M6
>
> Thank you
 | 
Pages: 1
Prev: Grouping dates on a Chart
Next: sum columns between certain dates