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.
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.
Last edited: