The attached adapted as per your requirements. Be aware the name formatting is not the same in both sheets, on the first one there is a space between the comma and the rest. ( hence the use of the SUBSTITUTE function)
I left everything blank if no name was found

Attached Files

Copy of 401k Deductions-1.xls (201.0 KB, 11 views)

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post