formula

[Srinivas]

Hi

I have categorized employees in different categories like a,b,c,d,e,f based
on this i want to deduct their P.F (A6) amount in their pay . Suppose if
A2=a then A6 should take the value of say a20, and if A2=b, then it should
take value of a21 like that.

Can any one tell me the formula.

Regards,

 

[Mike H]

Hi,

One way. Build a table somewhere out of the way looking like this I used Q1
to R6

a =A20
b =A21
c =A22
etc

Because of the formula (=A20etc) the table will end up showing the values in
A20 etc.

The use this formula

=VLOOKUP(A2,Q1:R6,2,FALSE)

Mike