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

How to use condition
 

Hi

F2=VLOOKUP(E2,$A$2:$B$1000,2,0)



--
Arvi Laanemets
( My real mail address: arvi.laanemets<attarkon.ee )



"RKS" wrote in message
...
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

How to use condition
 

Hi RKS

let's say your matrix with the product
and rate is in Cells A1 to B6 then
i would enter this formula in column F:
(example is for cell F2, in Cell E2 you enter
the Rate)

=vlookup(E2;$A$1;2;False)

hth
Carlo

"RKS" wrote:

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