If and Vlookup

H

Honey

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
 
B

Bob Phillips

=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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Store formulas in Vlookups? (another try ;) 6
SUMIF "value if false" not working 2
Vlookup to reference offset 1
Solver Problem ( related to earlier post of using if an Vlookup) 1
Vlookup help with function 1
Using If and Vlookup together. 4
vlookup issue 2
Look up or Match Function? Excuse my ignornace. This could be simple.Variable Upgrades on Furniture 1

Top