Indirect Formula: reference to two cells plus space?

[Bering]

Hello,

First of all, my apologies if this has been already answered in the past...

My problem: I have some sheets' names obtained by combining strings from two columns in a different sheet, separated by a space. So, based on the below example, my tabs' names could be:

A Monthly
D Monthly
B Annual

and so on....


[TABLE="width: 500"]
<tbody>[TR]
[TD]A[/TD]
[TD]Monthly[/TD]
[/TR]
[TR]
[TD]B[/TD]
[TD]Quarterly[/TD]
[/TR]
[TR]
[TD]C[/TD]
[TD]Semi-Annual[/TD]
[/TR]
[TR]
[TD]D[/TD]
[TD]Annual[/TD]
[/TR]
</tbody>[/TABLE]




I am trying to vlookup the sheets by using INDIRECT, however this only works if I remove the spaces in the sheets'names. Is it possible to take into account the space in my formula?

VLOOKUP($D3,INDIRECT($A$3&B$3&"!A:C"),2,0)

I tried this but, of course, it does not work

VLOOKUP($D3,INDIRECT($A$3&" "&B$3&"!A:C"),2,0)


Any suggestion would be grately appreciated.

Thanks.

 

[James006]

Hello,

You are only missing the Apostrophe '

=INDIRECT("'"&A3&" "&B3&"'"&........

Hope this will help

 

[Bering]

That works perfectly. Many thanks James

 

[James006]

You are welcome ...