View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
andy62 andy62 is offline
external usenet poster
 
Posts: 158
Default MIN across worksheets, with INDIRECT

Trying this again, with correction and clarification:

In the formula below, "$B$3" is a reference to the current worksheet which
contains a whole number to be used as a row reference on other worksheets.
This formula works when I pass a single-worksheet range to MIN, but not when
I pass a multi-sheet reference:

=MIN(INDIRECT("Rater1:Rater4!C"&$B$3))

Is there another way to type it, or do I need a more creative function?

TIA