I am trying to create a formula that will return the employee names and ID’s based on the Skill Name in cell A1 if the employee has a “Y” under that Skill Name. I have tried variations of xlookup, index, match, filter, and IF. I have spent hours googling trying to find something similar with no avail.

This question already has answers here: How can I search a range of multiple rows and columns for a value and return it’s header? (1 answer) In Excel, give a function to give column header value based on column values (1 answer) Reverse vlookup and concatenate (1 answer) Closed 6 hours ago. EXCEL: I have […]

I am doing a survey on Microsoft Forms and the reposnes are coming through as one string in one cell; as follows: