Worksheet Problem

[sparx]

Im trying to use the indirect command to bring together some cells that represent a worksheet in my workbook. One worksheet is called MLG1 and another worksheet is called MLG-1. When I use the indirect command another worksheet called " Results " and use the formula =INDIRECT(AU2&AV2) where AU2 = MLG1 and AV2 = !F11 I receive what is entered in MLG1-F11 where if I change cell AU2 in the Results worksheet for MLG-1 I receive the #Ref! error - why cant it see the " - " or spaces in the worksheet name!?

[Ardus Petus]

You have to type ''MLG-1' (single quote + single quote + MLG-1 + single
quote) into AU2

HTH
--
AP

"sparx" <[email protected]> a écrit dans le
message de news:[email protected]...
>
> Im trying to use the indirect command to bring together some cells that
> represent a worksheet in my workbook. One worksheet is called MLG1 and
> another worksheet is called MLG-1. When I use the indirect command
> another worksheet called " Results " and use the formula
> =INDIRECT(AU2&AV2) where AU2 = MLG1 and AV2 = !F11 I receive what is
> entered in MLG1-F11 where if I change cell AU2 in the Results worksheet
> for MLG-1 I receive the #Ref! error - why cant it see the " - " or
> spaces in the worksheet name!?
>
>
> --
> sparx
> ------------------------------------------------------------------------
> sparx's Profile:
http://www.excelforum.com/member.php...o&userid=16787
> View this thread: http://www.excelforum.com/showthread...hreadid=517260
>

[R..VENKATARAMAN]

Try
=indirect("au2")&indirect("av2")


"sparx" <[email protected]> wrote in
message news:[email protected]...
>
> Im trying to use the indirect command to bring together some cells that
> represent a worksheet in my workbook. One worksheet is called MLG1 and
> another worksheet is called MLG-1. When I use the indirect command
> another worksheet called " Results " and use the formula
> =INDIRECT(AU2&AV2) where AU2 = MLG1 and AV2 = !F11 I receive what is
> entered in MLG1-F11 where if I change cell AU2 in the Results worksheet
> for MLG-1 I receive the #Ref! error - why cant it see the " - " or
> spaces in the worksheet name!?
>
>
> --
> sparx
> ------------------------------------------------------------------------
> sparx's Profile:
> http://www.excelforum.com/member.php...o&userid=16787
> View this thread: http://www.excelforum.com/showthread...hreadid=517260
>

[sparx]

It worked - thanks

[CLR]

There may be some unseen typographical difference between your filename MLG-1
and the entry in your AU2 cell............use the Cell View add in available
free from Chip Pearson (www.cpearson.com) to check AU2 to see if there are
any additional "spaces".......

Vaya con Dios,
Chuck, CABGx3



"sparx" wrote:

>
> Im trying to use the indirect command to bring together some cells that
> represent a worksheet in my workbook. One worksheet is called MLG1 and
> another worksheet is called MLG-1. When I use the indirect command
> another worksheet called " Results " and use the formula
> =INDIRECT(AU2&AV2) where AU2 = MLG1 and AV2 = !F11 I receive what is
> entered in MLG1-F11 where if I change cell AU2 in the Results worksheet
> for MLG-1 I receive the #Ref! error - why cant it see the " - " or
> spaces in the worksheet name!?
>
>
> --
> sparx
> ------------------------------------------------------------------------
> sparx's Profile: http://www.excelforum.com/member.php...o&userid=16787
> View this thread: http://www.excelforum.com/showthread...hreadid=517260
>
>