View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
rayh rayh is offline
external usenet poster
 
Posts: 1
Default Can I lookup a value in a range of worsheets?

I also would like to figure out how to lookup a value in another workbook
across several worksheets in that workbook and return the value to a
worksheet in a different workbook.

"T. Valko" wrote:

And what do you want to do if this value is present?

Need more details

Biff

"Alex" <Alex @discussions.microsoft.com wrote in message
...
I would like to use a formula that will lookup a value within a specific
cell
over a range of worksheets. Similar to vlookup only for a range of
worsheets
instead of a table? Does anyone know how to do this?