raziel3
Registered User.
- Local time
- Today, 02:36
- Joined
- Oct 5, 2017
- Messages
- 275
Hello,
I have a table that stores rates for NI Contributions called Rates
and I have been using a Vlookup to return the Rate based on the employee Salary like this
Now that the rates have been increased (highlighted in the Rates Table attachment), how to get the new rates if I update the current Rate Table using the Effective Date. I've tried this:
but keeps getting an #N/A
I have a table that stores rates for NI Contributions called Rates
and I have been using a Vlookup to return the Rate based on the employee Salary like this
Code:
VLOOKUP(I4,'NIS AND TAX TABLE'!$E$2:$F$18,2).
Code:
{=INDEX(Rates,MATCH([@[PAY PERIOD END]]&AGGREGATE(14,6,Rates[EFFECTIVE DATE]/((Rates[MONTHLY SALARY]<=[@BASIC])*(Rates[EFFECTIVE DATE]<=[@[PAY PERIOD END]])),1),INDEX(Rates[MONTHLY SALARY],0),0))}
but keeps getting an #N/A
Last edited: