Forum Discussion
Sheet to search for name on other tabs
That could be like
=IF(ISNA(MATCH($B4,Table_1[[#All],[Column2]],0)),"-","x")but with repeated names that won't work correctly (e.g. you have two Andrea)
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")