Pete,
thank you; your formula is cleaner!
--
van0710
*to beautiful years in a beautiful city*


"Pete_UK" wrote:

In column A of your overview sheet you can list the sheet names that
you want to get data from - assume this starts in A2. Then in B2 you
can have this formula:

=INDIRECT("'"&A2&"'!B2")

and this one in C2:

=INDIRECT("'"&A2&"'!B4")

(Note the apostrophes). Then just copy these two formulae down for as
many sheets as you have listed in column A. If you have blanks in any
of those cells, the formula will return zero - you can avoid this by:

B2: =IF(INDIRECT("'"&A2&"'!B2")="","",INDIRECT("'"&A2& "'!B2"))
and:
C2: =IF(INDIRECT("'"&A2&"'!B4")="","",INDIRECT("'"&A2& "'!B4"))

and then copy down.

Hope this helps.

Pete

Hope this helps.

Pete

On Jan 4, 5:03 pm, van0710 wrote:
I have a workbook with many sheets and for every sheet I want to lookup the
values of multiple cells. With the address function I can create which cells
I want to lookup; but how can I get the value in those cells returned?

short descriptive:
worksheet names are 3039, 3058 (and more)
cell B2 of each sheet contains a name (say name is EXAMPLE on sheet 3039 and
EXHIBIT on sheet 3058)
cell B4 of each sheet contains a number (say number is 250 on sheet 3039 and
430 on sheet 3058)
I want to create an overview on a new sheet that shows me the values of
those cells.

--
van0710
*to beautiful years in a beautiful city*