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