I am using this formula to bring data from another spreadsheet file based on name of the month. This time for February..
=query(importrange("1L86iP0GLHTubwfvxs1kJ4ocbmgRAd4Iz0000000M","'February'!A2:F"),"Select Col6, Col5 where Col1 is not null",0)
But I would like to type the cell that has the month name instead of writing the month manually in each formula. If the cell C1="February" in file A and C1="January" in file B, how can I write C1 instead of month name in the formula? for example like this:
=query(importrange("1L86iP0GLHTubwfvxs1kJ4ocbmgRAd4Iz000000jbcM","'C1'!A2:F"),"Select Col6, Col5 where Col1 is not null",0)