Filtering values by V-lookup based on multiple column values

Paul Newcome

HERE is a link to a published sheet that contains the solution for parsing down a column from a list on a different sheet. My initial JOIN/COLLECT in String1 is going to be different because I pulled the data based on different criteria. The rest of the sheet though, you should be able to replicate for your sheet. This will parse the first set of data down your first column. Then you would set up another Comma and String column for your next list column, duplicate for your third list, etc. etc. All you would need to do is adjust your JOIN/COLLECT to pull the appropriate data.