The reference codes needed for the tables were mixed inside the Employee ID (like DR-K1.1995012),...The reference codes needed for the tables were mixed inside the Employee ID (like DR-K1.1995012),...
The network for creativity
Join 1.25M professional creatives like you
Connect with clients, get discovered, and run your business 100% commission-free
Creatives on Contra have earned over $150M and we are just getting started
Back to feedPost
Rheznandya 's avatar
Rheznandya Alisya
• Jul 19
The reference codes needed for the tables were mixed inside the Employee ID (like DR-K1.1995012), not written in separate columns. So, standard lookup formulas couldn't work normally.
Instead of manual inputs, I built advanced nested formulas to automate the entire process:
-LEFT & MID: To extract hidden codes and status keys from the Employee ID.
-VLOOKUP & HLOOKUP: To instantly pull data from reference tables using the extracted codes.
-IF & SUM: To handle dynamic allowance logic and calculate final net pay.
Microsoft ExcelexcelexcelautamationData AnalysisData Entry
Post image
Back to feed
The network for creativity
Join 1.25M professional creatives like you
Connect with clients, get discovered, and run your business 100% commission-free
Creatives on Contra have earned over $150M and we are just getting started