Vlookup FORMULA

[dcarey1]

Hi, I'm looking for a formula to do the following:

Formula C22:
Lookup Employee number VLookup - T_LOOKP,if match Lookup Age, if < 50 go to Admin and get maximium contributionamount else > 50 maximium.

vlookupemployee find
Traditional - calc methods and determine ifit is gross pay or default amount; if gross (rate*annual hours)*traditionalamount (percent). If it is default (fixed amount); Traditional Amount * payperiods)
Roth - calc methods and determine if it isgross pay or default amount; if gross (rate*annual hours)*traditional amount(percent). If it is default (fixed amount); Traditional Amount * pay periods)
Bothamounts added together < Limit or Limit is ending value



TL_LOOKUP

Irs Limits
Great_50	24500
Less_50	18500
Hours
Annual Full time	2080
Part Time Half Year)	1040
Pay Periods	52

 

[Special-K99]

Match where? Where are the ages stored? You havent said.
"Go To Admin and get maximum"
Whats Admin ? Is that a file, a sheet, something else ?


30 people have viewed this and noone has replied.
Because more info is needed.