View Single Post
  #1   Report Post  
coblad1357
 
Posts: n/a
Default I want to use if based on two cells (if... and)

cell1 =0
cell2 = "subject"

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