Indirect formula

[wiewie002]

Dear Team,
I used v-lookup so far to combine some sheet into 1 summary sheet.
so, need your advise for indirect formula.
details in attached file. Thank you in advance for your help.

Regards,
Wie

[shukla.ankur281190]

Try

C6

=VLOOKUP($A$4,INDIRECT("'"&TEXT($A6,"MMMYY")&"'!A1:AW7"),C1)

copy across

[wiewie002]

Dear Ankur,
Thank you.
If no use v-lookup and use row 5 as reference, which formula I can use?

Thank you in advance for your advise

[shukla.ankur281190]

May be try

C6

=VLOOKUP($A$4,INDIRECT("'"&TEXT($A6,"MMMYY")&"'!A1:EO7"),MATCH(EOMONTH($B6,0),INDIRECT("'"&TEXT($A6,"MMMYY")&"'!A3:EO3"),0)+(COLUMNS($C6:C6)-1),0)

[wiewie002]

Dear Ankur,
is work but row number 9 shown #NA

[shukla.ankur281190]

It is just because you have putted in sheet jan B3 04.01.2018 instead on 31.01.2018.

[wiewie002]

It's work. thank you so much for your help

[shukla.ankur281190]

Thanks for feedback. Please add reputation by clicking star icon left corner on your screen on those post which helps you.

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.