I am allowing students to choose three students with whom they wish to work. So Student A might choose Sudents X, Y and Z. What I need to do is determine if any or all of X, Y and Z also chose A so that I can pair them up. I envisaged shading the cells of the matching students. There are 60 or so students in total but this will vary. So I have a 60 x 4 array.

I have to jump to the row containing Xs record to see if she has selected A in any of her three choices, then do the same for Y and Z. And the whole thing has to be repeated for all 60 or so students. I understand the logic but am having trouble with the VB syntax that would allow me to use a student's name (the cell value) to jump to her record.

Thank you for any efforts on my behalf
Sally