C
Carolina
I have a form that I am creating and need your assistance. Currently I have
the following formula and it is working perfectly.
=IF($J$7="Small",VLOOKUP(A13,'Property
List'!$F$2:$G$31,2,FALSE),IF($J$7="Medium",VLOOKUP(A13,'Property
List'!$F$2:$H$31,3,FALSE),IF($J$7="Large",VLOOKUP(Sales!A13,'Property
List'!$F$2:$I$31,4,FALSE))))
The only thing is that now I need to add two more variables and I am unsure
how to proceed. Regardless if $JS7 is Small, Medium or Large I need the
formula to override if either any of the following happens:
IF(E13="SC",5)
or
IF(E13="SNF",3)
Thanks.
the following formula and it is working perfectly.
=IF($J$7="Small",VLOOKUP(A13,'Property
List'!$F$2:$G$31,2,FALSE),IF($J$7="Medium",VLOOKUP(A13,'Property
List'!$F$2:$H$31,3,FALSE),IF($J$7="Large",VLOOKUP(Sales!A13,'Property
List'!$F$2:$I$31,4,FALSE))))
The only thing is that now I need to add two more variables and I am unsure
how to proceed. Regardless if $JS7 is Small, Medium or Large I need the
formula to override if either any of the following happens:
IF(E13="SC",5)
or
IF(E13="SNF",3)
Thanks.