|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.
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
Any help with the syntax would be greatly appreciated.