View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Chip Pearson
 
Posts: n/a
Default Can vlookup be used to search in more than one worksheet?

You cannot have a VLOOKUP look in multiple sheets.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"Rufus T Firefly" <Rufus T
wrote in message
...
I have a workbook containing 12 worksheets (1 per month), each
contain a
table of 6 columns x 300 rows. There are drop downlists in
three columns and
i would like to create a printable report using vlookup to
return data into a
thirteenth worksheet.

So in short, I would like to enter a search criteria in sheet
13 that
searches the other 12 worksheets and returns the required
value.

I know you can use vlookup to return values found in another
worksheet but i
cannot get the formula to work when asking the vlookup to
search 12 sheets at
once.

Am I right in thinking it cannot be done?

Rufus T.