D
DCSwearingen
Is it possible to use a lookup function across multiple sheets?
Example:
A workbook contains 26 sheets. Can a function on Sheet1 look acros
sheet2 through sheet26 and if sheet9 cell A1 contains a specific valu
(only one of the sheets can contain the value) return the contents o
sheet9 cell A2
Example:
A workbook contains 26 sheets. Can a function on Sheet1 look acros
sheet2 through sheet26 and if sheet9 cell A1 contains a specific valu
(only one of the sheets can contain the value) return the contents o
sheet9 cell A2