Hi,

I know this sounds basic but it driving me crazy!

I need to do the following

If a1=0 then I want C1 = 0


If A1 =1 I want C1 to = the value from a lookup table ( solver will
add the value)

Thanks in advance,
Lyndsey