If Statements with Vlookup

[onebluekey]

Hi,

I am trying to write a vlookup statement where if there is an error, then check the GP% in another column. I am getting an error message: "Your formula is missing a parenthesis--) (.check the formula, and then add the parenthesis in the appropriate place.

I am not seeing where I should insert the parenthesis. Any help is appreciated. Thank you!


Lynn



=IFERROR(VLOOKUP(K2,Range,2,IF(AC2>=56%,"7- Above 56% GP",IF(AC2>=46%,"6- Between 46% - 55% GP",IF(AC2>=36%,"5- Between 36% - 45% GP",IF(AC2>=26%,"4- Between 26% - 35% GP",IF(AC2>=16%,"3- Between 16% - 25% GP",IF(AC2>=0%,"2- Between 0% - 15% GP","1- Less Than 0% GP"))))))

 

[onebluekey]

I found my own error. Thanks.