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....

A	Monthly
B	Quarterly
C	Semi-Annual
D	Annual

<tbody>
</tbody>

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 ...