I need to create a formula that will combine the employee and employer health care amounts for printing on the W2’s. My problem is that there are 4 different health deduction id’s, 4 different health fringe id’s and an HRA fringe id. I’m struggling to write the formula that will include all possible scenarios. I have no idea why there are 4 different fringe codes, just one would have worked fine, but its too late now my company has been using all 4 for years.
I currently have 4 different formulas…
LOOKUP(Prior Year Deduction [PR Employee Deduct], Employee [Employee], “HOSP-E”) + LOOKUP(Prior Year Fringe [PR Employee Fringe], Employee [Employee], “HOSP-E”) + LOOKUP(Prior Year Fringe [PR Employee Fringe], Employee [Employee], “HRA”)
This formula is repeated 3 more times for “HOSP-EC”, “HOSP-EF” AND “HOSP-ES”.
Any thoughts on how I can combine all into one formula?