I have the below on 2 separate data sheets, indicating if an employee is no
longer here or if a new employee. These are in column H of the data sheets.

=IF($A4130,IF(ISERROR(MATCH($B413,dataID,0)),"No Longer Here",""),"")

=IF(A5140,IF(ISERROR(MATCH($B514,PriorDataID,0)), "New Employee",""),"")

If a no longer here result is displayed in dataprior!H413, can I get the
cell value of A413 to display in another sheet, such as in cell B1 for the
first incident , the next in B2, ? The no longer here, and new employee
results are very random, and will be in various rows.

Thanks,

Steve