worksheet names in a formula

Giganews Newsgroups
Subject: worksheet names in a formula
Posted by:  Paul Schilling (pschilli…@uniplexcorp.com)
Date: Fri, 24 Oct 2003

Is there a way to have Excel look up information based on
the informationenteresd in a cell.

i.e.

you are in a worksheet named general and in cell a1 you
enter a city name.  I want Excel to look for the
information in the worksheet named the city referenced in
a1.

Any help with the syntax would be greatly appreciated.

Thanks,

Paul

Replies