Try incorporating MATCH into your formula.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Lee" wrote in message
...
=IF(B2="misc",E2,IF(OR(B2*1=I$2,B2*1=I$3,B2*1=I$4, B2*1=I$5,B2*1=I$6,B2*1=I$7,B2*1=I$8,B2*1=I$9,B2*1= I$10,B2*1=I$11,B2*1=I$12,B2*1=I$13,B2*1=I$14,B2*1= I$15,B2*1=I$16,B2*1=I$17,B2*1=I$18,B2*1=I$19,B2*1= I$18,B2*1=I$19,B2*1=I$20,B2*1=I$21,B2*1=I$22,B2*1= I$23),E2,E2*20/18))

Is there a better way to do the above formula? I have experimented with an
array but can't get it to work.
Thanks for any help or suggestions.
Lee