View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
RKS RKS is offline
external usenet poster
 
Posts: 63
Default How to use condition

Pl anybody help me.
Product Rate
a 1
b 2
c 3
d 4
e 5
Two column Product & Rate
Rate of a is 1 , B is 2, C is 3 ...etc. if I type a in column E then Rate
will be automatic in Column F. I have Lot of Product so I am not using IF
function. Pl help me other solution .
Thanks
RKS