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 ...
If you named the header row containing the month names on your second sheet and and the data itself you could use XMATCH to determine the starting column number you require from your data and use that to drop data from earlier months before selecting the data you require.
= LET(
colNum, XMATCH(month, monthHdr),
TAKE(DROP(monthlyData, , colNum-1), , 3)
)The formula returns a range reference so functions like TRIMRANGE can be used to capture data from tables of varying length.