In article ,
"T. Valko" wrote:

Download an install the free add-in Morefunc.xll...
=VLOOKUP(A2,THREED('Sheet1:Sheet5'!$B$2:$C$100),2 ,0)

I don't have this add-in. Does the THREED function require the sheets to be
in a contiguous order?

Biff

Actually, I don't have this add-in either. Unfortunately it's not
compatible with my Mac version of Excel. So I've never actually used it.

However, I suspect that it works in much the same way as a normal 3-D
reference -- all sheets between the two named sheets, inclusive. But
don't quote me... :)