If and Vlookup
 

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

If and Vlookup
 

=IF(A1=0,0,IF(A1=1,lookup_formula,""))

in C1

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)



"Honey" wrote in message
oups.com...

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