Try sumif function. The 1st argument is the range of employee numbers, the
2nd is the employee number you want to mathc, and the 3rd is the range with
the amount.

"vishu" wrote:

I have problem with vlookup formula. Vlook formula is picking up only one
amount. I will explain my problem with one example

I have one column with employee number (is repeating) and in another column
i have their salary breakups.

Employee no. amount

101 200
102 300
103 300
104 200
105 100
101 100
101 50

I have employee numbers in one sheet, if i put vlookup formula for employee
numbers i should get amount.
The problem is in Employee number 101. This is repeating thrice. In this
case its picking first amount. But i need sum of all amount it shoud give me
the amount 350 instead of 200

Please help me

I got your formula.
Can you please tell me what is thr use of Vlookup formula, If we can use
sumif everywhere. But i want to try to do it in Vlookup comand.
Is it possible.???


"Florida User" wrote:

Try sumif function. The 1st argument is the range of employee numbers, the
2nd is the employee number you want to mathc, and the 3rd is the range with
the amount.

"vishu" wrote:

I have problem with vlookup formula. Vlook formula is picking up only one
amount. I will explain my problem with one example

I have one column with employee number (is repeating) and in another column
i have their salary breakups.

Employee no. amount

101 200
102 300
103 300
104 200
105 100
101 100
101 50

I have employee numbers in one sheet, if i put vlookup formula for employee
numbers i should get amount.
The problem is in Employee number 101. This is repeating thrice. In this
case its picking first amount. But i need sum of all amount it shoud give me
the amount 350 instead of 200

Please help me