Hi Stephanie,

I don't know if this will help you but, this is what I used myself.

=LOOKUP(B2,{20,40,60,80},{"0","50","125","200"})

--
Newfie


"StephanieH" wrote:

I know I'm making this harder than it realy is, but right now I'm stuck. I
need a formula that will perform the following:
IF B4 = X then display "0"
IF C4 = X then display "50"
IF D4 = X then display "125"
IF E4 = X then display "200"

Any help would be appreciated.