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:
(all one cell)
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