Excel to Return timestamp from another cell

[mlathem1998]

How can I get this to return the timestamp that's in another cell? Where is has scan time, I need that to come from the scan list sheet.

This is where the timestamp is originating from. I need to have this copied to my list instead of saying "No".

Lastly:

I need any employees who have scanned and display the timestamp to show on this roster.

Basically I just need all my info to copy to this only if they have shown to have a timestamp. This will be my electronic roster with the class info for future records after the employee attend the class. I only want it to display everyone who scanned in the list above.

Sorry, I know I asked a lot, but I appreciate any help.

 

[Fluff]

Maybe

=ifna(VLOOKUP([@[Badge ID]],'Scan List'!A2:B100,2,0),"")

 

[mlathem1998]

Maybe

=ifna(VLOOKUP([@[Badge ID]],'Scan List'!A2:B100,2,0),"")

Yes, thank you. That worked for my first part of the post. Now, I just need to get this info populated to my roster which is the second part of my post.

 

[Fluff]

What have you tried?

 

[mlathem1998]

What have you tried?

I can do a simple ='s statement. I just don't know how add the data from a whole list of scanned employees for only those who scanned. one cell after the next.

 

[Fluff]

What is the name of the table you are trying to pull the data from?

 

[mlathem1998]

What is the name of the table you are trying to pull the data from?

From Here:

I only want to send information for those employees who scanned to the other training roster page. This example here shows only three employees. Those three employees would populate on the roster.

To Here:

The three employees would show up here if they were scanned.

 

[Fluff]

But what is the name of the table?

 

[mlathem1998]

But what is the name of the table?

From Employee List Badge excel sheet to Training Scan excel sheet. These are the tables you see in the screenshots.

 

[Fluff]

Yes but what is the name of the table on the Employee List Badge sheet?