I have a bunch of data which I tagged in category columns, and I want to make a sheet that pulls a range of data if it's tagged in a certain category column. In my case, columns A - E have the data I want, and columns F - T are the category columns.
Screen Shot 2016-03-16 at 11.14.22 AM.png
So for category F, I want to make a sheet that pulls the data from columns A - E that have anything (a checkmark) in column F. I assume INDEX/MATCH is the way to go for this, but so far I can't get it to work. I used =INDEX(Q1!A2:F900,MATCH("✔",Q1!F2:F900,0)) which at first seemed to work, but then I noticed for some reason it was pulling duplicates (even though there are no duplicate rows in the target range). Any idea why that would be or if there's a better way to accomplish this?
Sorry if this has been asked a million times, this has already eaten up so much of my time so I'm trying to find an answer as quickly as possible. If this has been covered in another thread, I'd be super grateful if you could link me to it!
Thank you so, so much in advance!![]()
Bookmarks