INDEX MATCH Formula
I have created a sign up sheet where individual participants can sign up to discuss with different groups in three consecutive slots. In order to sign up, they need to enter their full name into a cell. I am using the following formula to determine for which discussion a participant is signed up for in each slot:
=INDEX([Primary Column]2:[Primary Column]9, MATCH([Primary Column]@row, [SLOT 1 - participant 1]2:[SLOT 1 - participant 2]9, 0))
I can see that it is looking for the right thing because it says "no match" for Maria Carey in Slot 3, but I don't understand why it is returning completely random rows for all the others... or sometimes even "invalid value"... I am desperately in need of some help.
Help Article Resources
Check out the Formula Handbook template!