View Single Post
  #4   Report Post  
Old August 29th 05, 09:55 PM
Posts: n/a

Thank you, Dave! That was exactly what I needed!

"Dave Peterson" wrote:

You can use:

to concatenate a couple of cells.

To refer to that in another formula, you'd need something like:

=indirect("'" & a1&a2 &"'!A1")

or if there's a chance your concatenated string refers to a non-existing
worksheet and you want to avoid a #ref! error, you can check first:

=IF(ISERROR(CELL("address",INDIRECT("'"&A1&A2&"'!a 1"))),"missing",

(all one cell)

XLDabbler wrote:

I would like to concatenate cell values to create a name that corresponds to
a worksheet name and then use that in a formula. Does anyone know how to do


Dave Peterson