Download and install the free add-in Morefunc.xll from:
http://xcell05.free.fr/

....then use this formula

=VLOOKUP("your_criteria",THREED(Sheet1:Sheet40!A1: B100),2,0)


"jedman" wrote:

I am trying to use the vlookup to look at account numbers over 40 worksheets,
Is this possible to have the formula look in each worksheet without having to
type 40 different vlookups? I tried naming the range on each worksheet and
that is not working