Hello all!
I have an event that require card access to validate attendance.
Note: The card scanner populates cell B2 and overwrites the same cell after every scan.
<tbody>
</tbody>
When there is an ID match after the scan, I would like "Y" added in the SCANNER column then copy and paste as value within the same cell.
Philwojo gave me a formula to use -
Note: multiple scans are also possible.
I am completely stumped on how to make this work. Any ideas and help is appreciated.
I have an event that require card access to validate attendance.
Note: The card scanner populates cell B2 and overwrites the same cell after every scan.
A | B | C | D | E | F |
1 | ID SCANNER | SCANNED | ID | NAME | |
2 | 9000 | 8000 | BURNO | ||
3 | Y | 9000 | JAMES | ||
4 | 5000 | ADAM |
<tbody>
</tbody>
When there is an ID match after the scan, I would like "Y" added in the SCANNER column then copy and paste as value within the same cell.
Philwojo gave me a formula to use -
Code:
=IF(ISERROR(VLOOKUP(E6,$B$4,1,0)),"","Y")
I am completely stumped on how to make this work. Any ideas and help is appreciated.