View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
JW[_2_] JW[_2_] is offline
external usenet poster
 
Posts: 638
Default 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