Ok,
I have a sheet of about 500 rows of data. The first column contains course titles going all the way down to row 498. Each column title after that is the seat # for that particular course based on the size of the class. The names for each course and the corresponding students that have signed up for that course are listed in rows.Depending on the classroom size, each course has a different number of available seats which means there are blank cells in the table range of my data. What I'm trying to do is cross reference a specific student name against all of the columns that contain names of students who have signed up for a course and then highlight the values where there are matches. What would be even more ideal instead of going through the entire worksheet to look for the highlights is having it return all of the course titles (located in the first column down to row 498) for my reference value. I watched multiple videos on IF, COUNTIF and MATCH functions but I just can't get anything to work. I'm familiar with VLOOKUP but I need something that can return multiple values instead of one. I have spent 3 days trying to tackle this, please help!
I have a sheet of about 500 rows of data. The first column contains course titles going all the way down to row 498. Each column title after that is the seat # for that particular course based on the size of the class. The names for each course and the corresponding students that have signed up for that course are listed in rows.Depending on the classroom size, each course has a different number of available seats which means there are blank cells in the table range of my data. What I'm trying to do is cross reference a specific student name against all of the columns that contain names of students who have signed up for a course and then highlight the values where there are matches. What would be even more ideal instead of going through the entire worksheet to look for the highlights is having it return all of the course titles (located in the first column down to row 498) for my reference value. I watched multiple videos on IF, COUNTIF and MATCH functions but I just can't get anything to work. I'm familiar with VLOOKUP but I need something that can return multiple values instead of one. I have spent 3 days trying to tackle this, please help!