Thread: VLookup accross multiple worksheets
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
John C[_2_] John C[_2_] is offline
external usenet poster
  
Posts: 1,358
Default VLookup accross multiple worksheets
The site has been hacked.
--
** John C **

"Teethless mama" wrote:

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
Reply With QuoteReply With Quote