Two Column Autofill from Multiple Sheets

[Karan Pawar]

Hello,

PFA

Sheet1, B5 and F5 to be autofilled from other multiple sheets

Thank you,
Karan

 

[bosco_yip]

Try,

1] In "Sheet1" B5, copied down :

=VLOOKUP(A5,INDIRECT("'"&E5&"'!A3:F100"),2,0)&""

2] In "Sheet1" F5, copied down :

=VLOOKUP(A5,INDIRECT("'"&E5&"'!A3:F100"),6,0)&""

Regards
Bosco

 

[Karan Pawar]

Great Thank You Sir

 

[Karan Pawar]

Try,

1] In "Sheet1" B5, copied down :

=VLOOKUP(A5,INDIRECT("'"&E5&"'!A3:F100"),2,0)&""

2] In "Sheet1" F5, copied down :

=VLOOKUP(A5,INDIRECT("'"&E5&"'!A3:F100"),6,0)&""

Regards
Bosco

Sir,
Is it possible auto fill, sample file instead of single sheet if Physics,Chemistry,Bio.... are in different files
Thanks
Karan

 

[bosco_yip]

Maybe doable, please forward your sample file for us to check

Regards
Bosco

 

[Karan Pawar]

Maybe doable, please forward your sample file for us to check

Regards
Bosco

Dear Sir,
Please find attached
Thanks,
Karan