Multiple if statements

[FROGGER24]

In cell j2 will need formula to look at cell e2and if value =bz then result =7.2,if e2 = mx then result is 6.9, if e2 =or then result is 13.2,if e2 = pr then result 14.3,if e2 = to then result is 17.8, If none of these conditions apply then use this formula =(141/(g2+131.5)-.01111)*8.32

Thanks for any help provided!

 

[wideboydixon]

Book1
	E	F	G	H	I	J
2	aa		100			4.975038
Sheet4

Cell Formulas
Range	Formula
J2	=IFERROR(VLOOKUP($E2,{"bz",7.2;"mx",6.9;"or",13.2;"pr",14.3;"to",17.8},2,FALSE),(141/($G2+131.5)-0.01111)*8.32)

WBD

 

[FROGGER24]

Worked perfectly...thank you for your help