IF formula with VLOOKUP HELP!!!!!!

[mat08h]

Hi,
I am new here so i hope I am in the right place..

I need some help with a bit of a complicated spreadsheet i have set up as a product selector / order form. http://www.filedropper.com/copyofvalves

I have many cells referencing data from different worksheets but in one particular cell have the following formula =IF(B2="STO Act","0",VLOOKUP(C2,Act_STC,2,TRUE)) on the selector sheet that pulls data from another sheet when i select an Act STC valve. This is working fine but i need this to read 0 when any other value (man or Act STO) is selected from the drop down menu where the Act STC option is selected (if that makes sense?).

Any help would be greatly appreciated as it is driving nuts!!!!

 

[kevinb11]

Try this:

=IF(OR(B2="man",B2="STO Act"),"0",VLOOKUP(C2,Act_STC,2,TRUE))

 

[Sal Paradise]

You mean something like:

=IF(OR(B2="STO Act",B2="Act STO",B2="man")"0",VLOOKUP(C2,Act_STC,2,TRUE))

Or do you just mean, "If B2 is STC Act, then lookup, otherwise don't"

In which case:
=IF(B2<>"STC Act","0",VLOOKUP(C2,Act_STC,2,TRUE))

 

[mat08h]

Thanks Sal Paradise your second option worked a treat....

 

[Sal Paradise]

Glad I could help.