Try

=VLOOKUP(F5,{24,2400;18,1350;14,816;12,600;10,416} ,2,FALSE)

--

HTH

Bob

"Tina" wrote in message
...
I have a list box in F5 with 24, 18,14, 12,10. I need F7 to return if:
24=2400
18=1350
14=816
12=600
10=416

The first part of the below formula works, but I can't get it to work past
that. Could someone please help?

=IF(F5=(24),2400,If(or(f5=(18),1350)))

Thank you!