, Good evening.
I downloaded your Excel file.
I took a good look on it.
: (My opinion
The tabs EPF and SOCSO have a Structural Problem with the table.
Repeated values on a ordered list.
Missing conditions for value EQUAL to limit.
These aspects make the automatic search a task almost impossible.
These tabs present an unnecessary calculus on cells.
F4 = D4 E4
G4 = D4-E4
Is not necessary to have F4 and G4 at your Data Bank.
If on any moment you need these calculus, use then in the formula when necessary.
A lot of unnecessary formulas makes your Excel file bigger and slower, without give you any benefit.
I have a suggestion for you.
I created a tab "NEW SOCSO
The first 10 codes
At tab "Payroll Report-Jan (1)", I introduced a new formula and two new records
to show you as the formula and a new table at "New SOCSO" works.
I did this as an example for you.
If you like it, you can reorganize all your table at both: "SOCSO" and "EPF" tabs.
Here it is:
Make your tests.
Please, tell us if it worked for you.
I hope it helps.