Can I lookup a value in a range of worsheets?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Can Sheet name be part of formula for a cell (+ sheet name) 1
Can vlookup or hlookup look to other worksheets within a workbook. 1
Lookup returning wrong results 0
vlookup 1
Name ranges and Lookup 3
Using Value of a Cell in the Range Reference in VLOOKUP 1
Conditionally Formatting Cells based on Values in a Range (2007) 3
Scrabble Value calculation for Welsh words 0

Back
Top