Reference using worksheet name

Giganews Newsgroups
Subject: Reference using worksheet name
Posted by:  Trever B
Date: Wed, 10 May 2006

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) & CellC5

(Should be looking up Worksheet 80    & Cell C5

Your urgent help is required

Replies