Is it possible to use a lookup function across multiple sheets?

Example:
A workbook contains 26 sheets. Can a function on Sheet1 look across
sheet2 through sheet26 and if sheet9 cell A1 contains a specific value
(only one of the sheets can contain the value) return the contents of
sheet9 cell A2.


--
DCSwearingen


------------------------------------------------------------------------
DCSwearingen's Profile: http://www.excelforum.com/member.php...o&userid=21506
View this thread: http://www.excelforum.com/showthread...hreadid=399630