Update data from another sheet using criteria

Occasional Visitor



I have an excel file that is used to update the payroll journal entry allocation. we use the ADP data from a second sheet to update the journal schedule. As of now it is updated manually twice a month. how do i create a formula to using maybe the staff name or employee ID, to pull the amounts and update automatically as soon as the new data is dumped? 

please help, thank you   

1 Reply


That could be any lookup formula (XLOOKUP, INDEX/MATCH, etc) depends on your Excel version.  But that's better to discuss with small sample which illustrates how data is structured.