Hi,
I am using INDEX/MATCH to look for the team leaders name in row 1 and then to return the advisors name from the list below it, when I use this I get data from the first or second column relating to a different TL name.
Any ideas what I am doing wrong? I have attached a pic of what I have.
I am using INDEX/MATCH to look for the team leaders name in row 1 and then to return the advisors name from the list below it, when I use this I get data from the first or second column relating to a different TL name.
Any ideas what I am doing wrong? I have attached a pic of what I have.