Forum Discussion
Checking for Value in Cell and returning all Values from corresponding row?
Hey there !
Just need some help with organising information from one central Sheet into various other Sheets (in this case - a Sheet for each month of the year). I have information coming in from a Microsoft Form that has a column for what month the Participant filled the Form in and I am hoping to create a Sheet for each month that will only contain the responses for that month (e.g. all July responses in the July Sheet - August responses in the August Sheet, etc).
I was trying with a formula that looked like this: =XLOOKUP("August", 'MainSheet'!$B$2:$B$1000, 'MainSheet'!$A$2:$K$1000) - where B is the column containing the month and A-K contains all information.
My problem is that this will only ever return the first response that contains August because it is searching the same set of data chronologically but I am looking for a formula that will find the first instance of August - return that row - then find the next instance - return that row and so on and so forth !
Hope this makes sense :) and thank you for the help !!!
=FILTER(MainSheet!A2:K1000,MainSheet!B2:B1000="August")FILTER returns the expected result in my sample sheets.
2 Replies
I understand what you're trying to do — you're looking to filter and display all responses from the main sheet that correspond to a specific month (like August), on a separate sheet for that month, rather than just the first match.
=FILTER(MainSheet!A2:K1000,MainSheet!B2:B1000="August")FILTER returns the expected result in my sample sheets.
