I want to use if based on two cells (if... and)

[Guest]

cell1 =0
cell2 = "subject"

If cell1= 0 and cell2="sub1" then use a lookup table else answer=25

 

[Guest]

try
=if(and(cell1=0,cell2="sub1"), lookup,25)

 

[Guest]

=IF(AND(C1=0,C2="sub1"),lookup_formula,25)


Regards,

Peo Sjoblom