IF formula help

[jooniper]

I have a massive spreadsheet of people and their qualifications. Vlookup will only return their first qualification on the list, but I need to know each one by line. I’m trying to use an “IF AND” statement. So, if column 1 contains the persons name and column 2 contains qualification name 1 (at the head of that particular column) then “yes” otherwise “no”, And copying it across the whole row so each name has the corresponding qualification header but it doesn’t seem to be working. Any help?

 

[sandy666]

try PowerQuery (Get&Transform)