Forum Discussion
Sheet to search for name on other tabs
You are a gent SergeiBaklan !
That is exactly what I need.
On your version we will have last names too. That was just a dummy sheet.
Thank you very much, you spared another soul hours of purgatory!
Have a great weekend!
Rafael
Rafaelbf1985 , you are welcome, glad to help
If I could abuse a bit more of you kindness and knowledge, could I ask you for one further question?
On the formula you helped me with, it works perfectly, although one of the other teachers had the request of the formula displaying the data found instead of an "x", for one of the many parameters we monitor.
What I am trying to say is, one of things we monitor, is the attendance, which would always be a number between zero and "something".
Is there a way to adapt this formula to instead of diplaying "-" or "x" it would display the found number for that name?
The data is on column "M" on sheet "PRESENCE_COUNT"
Again thank you very much for your help!
=IF(ISNA(MATCH($A116,PRESENCE_COUNT!$M$4:$M$1002,0)),"-","x")
Apologies, I forgot to upload an updated version.
So the number found on the column M "CountPresence" of the tab PRESENCE_COUNT, to appear on the All_Students tab column H.
As before, it would need to search for the entry based on the name (each student would have name and last name to avoid conflicts)
And Ideally, it display the found number please.
Once more, very appreciated for helping with this.
Thank you
Rafael