Forum Discussion
Excel : IF/THEN on multiple column and ANY sheets
Thank you so much for your quick response 🙂
Could you explain me the purpose of the column K in your formula ?
Does it mean that I have to create an other column in my first sheet (participant details) with the list of all the other sheets (training dates) ?
Just to make sure I understand properly 🙂
Kindly,
Audrey
PS : You are amazing !! Thank you so much ♥
Yes, you have to create a range of cells on your first sheet with the names of your training data sheets.I used column K, but it can be anywhere you want. Adjust the formulas in column F accordingly.
- Nvm, it's not working 😞
If you don't have Microsoft 365 or Office 2021, you may have to confirm the formula with Ctrl+Shift+Enter each time you edit it.
And keep in mind that I created only 4 extra sheets, so I used $K$2:$K$5. If you have 25 training date sheets, for example, use $K$2:$K$26.
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 !
- Ohh I think I found my mistake. It's the way I named the sheets !
- Hi Hans,
Thanks again for your quick response ! I've been trying since the past 2 hours to adapt the formula to my excel file, and yet, it's not working 😞 But in your Excel it's ok ! I have #REF and #VALEUR mistakes in 90% of my column F. And on the other 10%, it says NO, even if the name of the participant is written in a training sheet.
I used the exact same column as you, to be certain that there would not be any mistakes, and yet !