Hi Team,
There is a path which contains 30 excel files and i have to do vlookup from each 30 excel files to single column in another different excel file how do i achieve this
Can you please give some sample input and output excels. It’s no problem you can provide dummy excel files.
Cheers!!
Could you please show sample like how it’s being done currently? Looks interesting to work on 
Thanks,
Ashok 
Hi,
Here in the below screenshot we have some 12 functions consider this as output sheet, so since there are 12 functions there will be 12 different excel files saved in a path which contains numbers in each and every month so now in the below
output sheet i have to do vlookup to fetch the current month values from each sheets and add the values to current month in output sheet for each corresponding functions.
so this is one example file for “A” function so here i have to fetch march month values and add it in output sheet March column
like this i have to fetch March values from each and every fucntion sheets and add it in output.
Output
