Multiple Vlookup with and or formula twice

[slohman]

I would like to use this formula that works but I need it to look at other criteria's

What I have
=IF(AND($E$12="Kelvcon",$F$281>=0),VLOOKUP(@$A:$A,Master!AF:AR,10,"False")*$F$281)

What I would like
=IF(AND($E$12="Kelvcon",$F$281>=0),VLOOKUP(@$A:$A,Master!AF:AR,10,"False")*$F$281), IF(AND($E$12="Outdoor",$F$281>=0),VLOOKUP(@$A:$A,Master!CD:CP,10,"False")*$F$281)
but this doesn't work.

I know if will be a simple fix but I cant work it out.

 

[mart37]

Master!CD:CP means that VLOOKUP looks in the first column CD to the value of @$A:$A. In the first VLOOKUP it looks to column AF.

 

[slohman]

Yes what I would like is Kelvcon in E12 and F281of they have text or number then column A:A matches Master AF:AR then it takes an amount and multiples it but if Outdoor is in E12 then find the match in A:A and Master CD:CP and multiple that with F281.

 

[mart37]

=IF(AND($E$12="Kelvcon",$F$281>=0),VLOOKUP(@$A:$A,Master!AF:AR,10,"False")*$F$281), IF(AND($E$12="Outdoor",$F$281>=0),VLOOKUP(@$A:$A,Master!CD:CP,10,"False")*$F$281)

 

[slohman]

TIA

I can get the first of the formula to work but when I put the second if formula in it turns into a #VALUE they work separately but not together.

=IF(AND($E$12="Kelvcon",$F$281>=0),VLOOKUP(@$A:$A,Master!AF:AR,10,"False")*$F$281), IF(AND($E$12="Outdoor",$F$281>=0),VLOOKUP(@$A:$A,Master!CD:CP,10,"False")*$F$281)

 

[Fluff]

You had a bracket in the wrong place try

=IF(AND($E$12="Kelvcon",$F$281>=0),VLOOKUP(@$A:$A,Master!AF:AR,10,"False")*$F$281, IF(AND($E$12="Outdoor",$F$281>=0),VLOOKUP(@$A:$A,Master!CD:CP,10,"False")*$F$281,""))

I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

 

[slohman]

You had a bracket in the wrong place try

=IF(AND($E$12="Kelvcon",$F$281>=0),VLOOKUP(@$A:$A,Master!AF:AR,10,"False")*$F$281, IF(AND($E$12="Outdoor",$F$281>=0),VLOOKUP(@$A:$A,Master!CD:CP,10,"False")*$F$281,""))

I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

Thank you to you both. Works perfectly

 

[Fluff]

Glad we could help & thanks for the feedback.