Forum Discussion
Sheet to search for name on other tabs
Hi guys, I've been trying to create an attendance sheet for the school I work for, but I didn't manage to achieve what I need using the little I've seen around or found on the internet. I hope someone can advise me please.
The sheet I am trying to do, has a tab with "all students", and its contact details.
The next few tabs are of students that meets certain criteria like, "didn't book" a revision class, "booked 1st class", "attended 1st class", and "didn't attend the 1st" class.
I would like to be able to bring in all the date to the first tab, and the "search" to be based on their name, as the software would be constant on this (bear in mind it does have a space between name and last name, as I noticed it was an issue with what I tried)
So lets say, students that didn't book a class at all, the cell corresponding to that student on tab A column H, would turn red, or place a Yes or a No, some sort of marking which I can then sort by that.
Bear in mind, I will have to update the attendance tabs monthly, if that makes any difference. I uploaded a sample sheet.
Any help is very appreciate and I promise to pass the kindness forward.
Rafael
9 Replies
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
