Hi All,

I was wondering if someone could help me out with an error that I'm getting.

I am able to get this to work:

=IF(G25="Associate Degree", LOOKUP(G26,{1,7,13,19},{3,5,7,9}),0)

This is what I ultimately need to have but I keep getting a #NAME error:

=IF(G25=”Associate Degree”, LOOKUP(G26,{1,7,13,19},{3,5,7,9}),IF(G25=”Undergraduate Degree”, LOOKUP(G26,{1,4,7,10,13,16,19,22},{2,3,4,5,7,8,9,10}),IF(G25=”Graduate Degree”, LOOKUP(G26,{1,4,7,10,13,16,19,22},{2,3,5,6,8,9,11,12}),IF(G25=”Doctoral Degree”, LOOKUP(G26,{1,4,7,10,13,16,19,22},{2,3,5,6,8,9,11,12}),0))))

Any assistance would be appreciated. Thanks!