Use INDIRECT to build a dynamic reference is causing #REF error

I am tying to use Indirect to build a dynamic statement. I keep getting the #REF error and I haven't been able to figure out how to do it correctly.

I have the pieces of the reference in different cells.

A1 = MW
A3 = 01

and the cell on the tab I want to reference is L27 (just for kicks it equals 3,003)

I am constructing the Indirect statement as such:

Formula:

Please Login or Register  to view this content.

and I need it to return this:

Formula:

Please Login or Register  to view this content.

Any help would be greatly appreciated. Thank you!!

Try it like this:

=INDIRECT("'" & A1 & " " & A3 & "'!L27")

You had some spaces in there which adds to the reference, and so it did not match with your tab names. Also, the L27 should be inside the quotes.

Hope this helps.

Pete

Thank you all for the responses. You have solved my problem. It was those extra spaces and not pulling the tab's cell reference into the quotes that killed me.

As always, the Excel forum is the best ever!!!!

Cliff