Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 12
Default Can I lookup a value in a range of worsheets?

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?
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 15,768
Default Can I lookup a value in a range of worsheets?

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?



  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
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?




Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
duplicating worsheets Don Excel Worksheet Functions 2 November 28th 06 07:11 PM
Is it possible to combine two worsheets into one Pivot Table? Diane13 Excel Worksheet Functions 2 August 3rd 06 07:16 PM
Link worsheets in Excel Djasabe Excel Worksheet Functions 2 June 2nd 06 08:15 PM
Connecting Worsheets when there is a filter [email protected] Excel Discussion (Misc queries) 0 May 4th 06 04:38 PM
Linking 2 Worsheets Mike_C Links and Linking in Excel 3 August 10th 05 11:14 PM


All times are GMT +1. The time now is 12:22 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"