SMALL function across different sheets?

[zanguard80]

Is there any way to use ranges contained in separate sheets as part of a SMALL function's argument? For example, this works:

Please Login or Register  to view this content.

But this returns a #VALUE error:

Please Login or Register  to view this content.

[FDibbins]

I dont think small works on 3-d ranges/sheets. Try breaking them out?
=small(small(1st-sheet,1),small(2nd-sheet,1),small(3rd-sheet,1).................,1)

[Shareez Saleem]

=MIN(SMALL(Sheet1!A1:B1,1),SMALL(Sheet2!A3:B3,1))

[FDibbins]

=MIN(SMALL(Sheet1!A1:B1,1),SMALL(Sheet2!A3:B3,1))

I guess MIN would be simpler than another SMALL

[zanguard80]

I figured out a solution:

Please Login or Register  to view this content.

This returns the values contained in the two ranges as a 2D array and works with the SMALL function. I don't know why Excel doesn't do this in the first place, but hey-ho...