Thread: IF..., then....
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
JcR
 
Posts: n/a
Default IF..., then....

If value in cell a1 = value in cell a2 or a3 or a4, then display the value in
cell b2 in cell c2
If value in cell a1 = value in cell a5 or a6 or a7, then display the value
in cell b5 in cell c2
If value in cell a1 = value in cell a8 or a9, then display the
value in cell b8 in cell c2