View Single Post
  #1   Report Post  
DBickel
 
Posts: n/a
Default Reference the worksheet from a multiple worksheet range function (

I want to reference the worksheet that is returned when I do a 3-D reference
function.

For example:
If on worksheet "1" of 40 I have this formula:
=MAX('2:40'!I4)

It will return the maximum value, but I need to know which worksheet had the
maximum value. Suggestions? Please?