Combining two vlookup if statements

[dcarey1]

I have two lookup if statements that work perfectly in two different cells. One checks the value if the calculation is < Add_med_limit and the 2nd >=Add_med_limit. When I try to combine them in one statement either gives error statement or #value . I tried to combine by adding , after first statement no luck.




=IFERROR(IF(VLOOKUP(TEXT($E$3,"000"),TL_LOOKUP,13,FALSE)*ANNUAL_HRS+VLOOKUP(TEXT($E$3,"000"),TL_LOOKUP,14,FALSE)<ADDL_MED_LIMIT,VLOOKUP(TEXT($E$3,"000"),TL_LOOKUP,13,FALSE)*ANNUAL_HRS+VLOOKUP(TEXT($E$3,"000"),TL_LOOKUP,14,FALSE))*MEDICARE_RATE,0)


=IFERROR(IF(VLOOKUP(TEXT($E$3,"000"),TL_LOOKUP,13,FALSE)*ANNUAL_HRS+VLOOKUP(TEXT($E$3,"000"),TL_LOOKUP,14,FALSE)>=ADDL_MED_LIMIT,VLOOKUP(TEXT($E$3,"000"),TL_LOOKUP,13,FALSE)*ANNUAL_HRS+VLOOKUP(TEXT($E$3,"000"),TL_LOOKUP,14,FALSE))*(MEDICARE_RATE+ADDIT_MED_RATE),0)

 

[Aladin Akyurek]

What do you mean by "adding"? Care to provide example results from each VLOOKUP and the end result that you want?