shaikhrulez
Active Member
Hello everyone,
I am stuck in vlookup formula. I was wondering if there is a way I can concatenate a text and use it as a cell reference to other sheets in a vlookup formula?
Please refer image below.
I want to use values of first row as cell reference which will eventually link to specified sheet in my workbook.
For example
My existing formula is =VLOOKUP($A2,'04.07.2018'!$A:$C,3,0)
Is there a way I can use above formula like this. VLOOKUP($A2,'C1'!$A:$C,3,0)
so that when I drag my formula cell reference automatically adjust according to first row.
Thanks.
I am stuck in vlookup formula. I was wondering if there is a way I can concatenate a text and use it as a cell reference to other sheets in a vlookup formula?
Please refer image below.
I want to use values of first row as cell reference which will eventually link to specified sheet in my workbook.
For example
My existing formula is =VLOOKUP($A2,'04.07.2018'!$A:$C,3,0)
Is there a way I can use above formula like this. VLOOKUP($A2,'C1'!$A:$C,3,0)
so that when I drag my formula cell reference automatically adjust according to first row.
Thanks.