I have two tables: in **Table 1** I have the names of the students who registered for the examination, in **Table 2** I have the names who actually showed up for the examination.
I would like to set up a function that allows me to say for each name present in Table 1: if it is present also in Table 2, then copy its vote; if it is not present in Table 2, write "Absent".
Is this possible?
Another approach is to use IF and COUNTIF:
The formula shown below the "registered" table is entered in cell C2, and filled down to the bottom of that table.
The formula returns the first value ("Present" ) if the COUNTIF result for the name in column A of Register is greater than zero, or "Absent" if the count of that name is zero.
The Conditional Highlighting rule shown below sets the cell's fill colour to green if the text in that cell in column C of Registration is "Present" and leaves the cell with "No Fill" if there is any other text (or no text at all) in the cell.
Regards,
Barry
It sounds like you need the XLOOKUP function
it allows for an argument for when an item is not found. You could use that to put the “absent” in when the students name wasn’t on the table 2
jason
Apple Numbers: copy values or write "Absent"
