Lookup for worksheet name

  • Thread starter Thread starter Snay
  • Start date Start date
S

Snay

Does anyone know if there is a possibility to make a reference in
formula to one of a number of worksheets, depending on a value which
enter?

For example:

If cell A1 has the text content"Sheet 1", take thevalue of Cell B23 i
Worksheet 1, if cell A1 has the value "Sheet 2", take teh value of cel
B23 in Worksheet 2.

Thanks for an answer!

Regards

To
 
Tom

=INDIRECT(A1&"!"&"$B$23")

If you have many sheets to pick from set up a Data>Validation>List drop-down
in A1.

Gord Dibben XL2002
 
Back
Top