Forum Discussion
Looking up specific period financials from multiple period worksheet
Hello, I have the following sample data: The data from Column I onwards is in a different worksheet in the layout that you see above. I need to be able to bring in the July data as shown ...
Hi Peter,
Thank you for your response above. I am unable to follow through the steps that you have outlined above. I tried another function to no success: a combination of Index and XMatch as follows:
The monthly data has been moved to another worksheet: Sheet1. I am most definitely not understanding the argument logic in the above function. Please let me know if you can nudge me a little further in the right direction. Thank you.
Please attach a sample workbook and show your expected result clearly.