Vlookup in multiple sheets
 

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

Vlookup in multiple sheets
 

See he
http://www.ozgrid.com/VBA/VlookupAllSheets.htm
Luis A. Vázquez wrote:
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