Matching column data

[GAP5229]

I have a need to match data from one column to another and then post in a third column (received) Using a scanner to read a barcode to post in the second column. Want the number posted to look at column one and find the matching number and then reach to a hidden cell to pick up the (Received) and post in column three.
Scan
A B C
12345 12347 Received
12346 12345
12347 Received

 

[Special-K99]

in C1
=IF(NOT(ISNA(MATCH(B1,A$1:A$10000,0))),"Received","")
and copy down the column

 

[GR00007]

Here's another thought (very similar to Special-K99), I'm assuming Column A is the sent scan and B is the received scan.
=IFERROR(IF(MATCH(A1,B:B,0),"Received",""),"")
Place in C1 and copy down

 

[GAP5229]

Here's another thought (very similar to Special-K99), I'm assuming Column A is the sent scan and B is the received scan.
=IFERROR(IF(MATCH(A1,B:B,0),"Received",""),"")
Place in C1 and copy down

Thanks, this works great. How could I add the date of the posting in the next column . Want it to automate when the data shows up in column B and stay.

 

[GR00007]

Just keep the formula in C extended to match the rows entered in A. Any new value in B that matches will be updated in C immediately after entry.

 

[GAP5229]

Did not give me date. I want it to post the date in C automatically and not change each time I open it.

A B C
123 123 Date
Formula Auto date