formula

S

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,
 
M

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Formula Question 2
Help with Cell Formula 4
Formulas won't drag down the column 2
Move data from first 7 rows from one column A into multiple Columnsthen the next 7 rows 2
Index, Match within a range of values 4
Display maximum value of matching values in a different column 7
How do you repeat a function in a formula 4
With F1 value, look at A, if match or partial match return B 5

Top