Vlookup in multiple sheets

[Luis A. Vázquez]

Hi guys,

I cant seem to get going a vlookup formula to look thru different work
sheets in the same workbook, What i have is this.

=vlookup(d9,'sheet2:sheet30!',d8:g300,2,false)

How to do, to make that vlookup search thru all the workbook? Thnx

 

[JW]

See here:
http://www.ozgrid.com/VBA/VlookupAllSheets.htm