Forum Discussion

AudreySC's avatar
AudreySC
Copper Contributor
May 16, 2022

Excel : IF/THEN on multiple column and ANY sheets

Hi,    I would like to create an Excel file that will allow me to see if a participant has done a certain training or not. I have a sheet in Excel with the name of the participants (in column A), t...
excel
Formulas and Functions
AudreySC's avatar
AudreySC
Copper Contributor
May 16, 2022

Hi HansVogelaar ğŸ™‚

Thanks again for your quick response !

Yes I have actually eleven sheets, so I changed K5 for K13.

Weirdly, the first 10 participants are working. But when I get to the participant at F14, I have the problem #VALEUR. 

 

As well, it seems to work for the line HARRY POTTER, but not the line SHER ?

Wath am I doing wrong ? 


Edit : sorry.... can't seem to be able to add my .xlsx file. It says that it is not supported.

 

Thank you so much for your help !

  • AudreySC's avatar
    AudreySC
    Copper Contributor
    May 25, 2022
    Thank you !!! It worked 🙂

Resources