software

Hi,

Thanks in advance

Column B = Ref No of Client (which = worksheet Name(Which is a No)

I want column C to Look up Cell B(Which equals to Worksheet Name) Followed
By Cell C5 of That Woksheet to give be contents of that cell. How do I link
it

Col B C
Row 2 80 =Worksheet(B2) amp; CellC5

(Should be looking up Worksheet 80 amp; Cell C5

Your urgent help is required
Try:
=INDIRECT(quot;Worksheetquot;amp;b2amp;quot;!C5quot;)

HTH
--
AP

quot;Trever Bquot; gt; a écrit dans le message de
news: ...
gt; Hi,
gt;
gt; Thanks in advance
gt;
gt; Column B = Ref No of Client (which = worksheet Name(Which is a No)
gt;
gt; I want column C to Look up Cell B(Which equals to Worksheet Name) Followed
gt; By Cell C5 of That Woksheet to give be contents of that cell. How do I
gt; link
gt; it
gt;
gt; Col B C
gt; Row 2 80 =Worksheet(B2) amp; CellC5
gt;
gt; (Should be looking up Worksheet 80 amp; Cell C5
gt;
gt; Your urgent help is required
gt;
gt;
Put in C2: =INDIRECT(quot;'quot;amp;B2amp;quot;'!C5quot;)
Copy down
--
Max
Singapore
savefile.com/projects/236895
xdemechanik
---
quot;Trever Bquot; wrote:
gt; Hi,
gt;
gt; Thanks in advance
gt;
gt; Column B = Ref No of Client (which = worksheet Name(Which is a No)
gt;
gt; I want column C to Look up Cell B(Which equals to Worksheet Name) Followed
gt; By Cell C5 of That Woksheet to give be contents of that cell. How do I link
gt; it
gt;
gt; Col B C
gt; Row 2 80 =Worksheet(B2) amp; CellC5
gt;
gt; (Should be looking up Worksheet 80 amp; Cell C5
gt;
gt; Your urgent help is required

That was really helpful and solved a big problem for me. But- where did you
find the syntax for a worksheet reference in the Indirect function? My help
file only explains cell references.

Thanks,
Kevinquot;Maxquot; wrote:

gt; Put in C2: =INDIRECT(quot;'quot;amp;B2amp;quot;'!C5quot;)
gt; Copy down
gt; --
gt; Max
gt; Singapore
gt; savefile.com/projects/236895
gt; xdemechanik
gt; ---
gt; quot;Trever Bquot; wrote:
gt; gt; Hi,
gt; gt;
gt; gt; Thanks in advance
gt; gt;
gt; gt; Column B = Ref No of Client (which = worksheet Name(Which is a No)
gt; gt;
gt; gt; I want column C to Look up Cell B(Which equals to Worksheet Name) Followed
gt; gt; By Cell C5 of That Woksheet to give be contents of that cell. How do I link
gt; gt; it
gt; gt;
gt; gt; Col B C
gt; gt; Row 2 80 =Worksheet(B2) amp; CellC5
gt; gt;
gt; gt; (Should be looking up Worksheet 80 amp; Cell C5
gt; gt;
gt; gt; Your urgent help is required

Help explains that INDIRECT uses the cell contents of the referenced cell.

In this case B2 contains the sheetname.

You could also use a construct like this if your sheetnames are the standard
sheet1, sheet2 etc.

=INDIRECT(quot;Sheetquot; amp; (ROW()) amp; quot;!C5quot;)

entered in row 1 and copied down.Gord Dibben MS Excel MVPOn Tue, 23 Sep 2008 08:30:13 -0700, Hollingshead
gt; wrote:

gt;That was really helpful and solved a big problem for me. But- where did you
gt;find the syntax for a worksheet reference in the Indirect function? My help
gt;file only explains cell references.
gt;
gt;Thanks,
gt;Kevin
gt;
gt;
gt;quot;Maxquot; wrote:
gt;
gt;gt; Put in C2: =INDIRECT(quot;'quot;amp;B2amp;quot;'!C5quot;)
gt;gt; Copy down
gt;gt; --
gt;gt; Max
gt;gt; Singapore
gt;gt; savefile.com/projects/236895
gt;gt; xdemechanik
gt;gt; ---
gt;gt; quot;Trever Bquot; wrote:
gt;gt; gt; Hi,
gt;gt; gt;
gt;gt; gt; Thanks in advance
gt;gt; gt;
gt;gt; gt; Column B = Ref No of Client (which = worksheet Name(Which is a No)
gt;gt; gt;
gt;gt; gt; I want column C to Look up Cell B(Which equals to Worksheet Name) Followed
gt;gt; gt; By Cell C5 of That Woksheet to give be contents of that cell. How do I link
gt;gt; gt; it
gt;gt; gt;
gt;gt; gt; Col B C
gt;gt; gt; Row 2 80 =Worksheet(B2) amp; CellC5
gt;gt; gt;
gt;gt; gt; (Should be looking up Worksheet 80 amp; Cell C5
gt;gt; gt;
gt;gt; gt; Your urgent help is required