Can I lookup a value in a range of worsheets?

A

Alex

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

rayh

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