worksheet names in a formula

  • Thread starter Thread starter Paul Schilling
  • Start date Start date
P

Paul Schilling

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
 
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.
Click to expand...

Have you tried:
='the city'!A1
 
I thought you were looking for something like:

=INDIRECT("'" & A1 & "'!b1")

Put the Chicago in A1 and this formula will return the value from B1 of the
worksheet named Chicago.

The single quotes are necessary for names containing spaces--San Francisco. But
won't hurt for the other names.
 
Back
Top