Card Reader Lookup

[WWII_Buff]

Hello all!

I have an event that require card access to validate attendance.
The card scanner populates B2 and overwrites after every scan.

[TABLE="class: grid, width: 300"]
<tbody>[TR]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[TD]E[/TD]
[TD]F[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]ID SCANNER[/TD]
[TD][/TD]
[TD]SCANNED[/TD]
[TD]ID[/TD]
[TD]NAME[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]9000[/TD]
[TD][/TD]
[TD][/TD]
[TD]8000[/TD]
[TD]

BURNO
[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD][/TD]
[TD][/TD]
[TD]Y[/TD]
[TD]9000[/TD]
[TD]JAMES[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]5000[/TD]
[TD]ADAM[/TD]
[/TR]
</tbody>[/TABLE]

When there is an ID match after the scan, I would like "Y" added in the SCANNER column.

Note: multiple scans are possible.

I am completely stumped on how to make this work. Any ideas and help is appreciated.

 

[philwojo]

You could try this, paste in to D2 and copy down as needed, you will need to update the range as I only set it form B2:B20, so if your range is larger than B20 just increase that number. One last thing, this does not take in to account duplicates, it assumes a Scanned value will be unique and will only look for the 1st instance of it.

=IF(ISERROR(VLOOKUP(E2,$B$2:$B$20,1,0)),"","Y")

 

[WWII_Buff]

Thanks for the response Phil! OK this is awesome. The second problem is the card reader doesn't arrow down to the next cell below, it simple overwrites B2.

I think a macro that would copy & paste special value a specific cell when a "Y" was returned would work.

 

[philwojo]

I am not familiar with card reader stuff, I would recommend posting a new thread for that topic as it is a different issue from this one.