VLOOKUP Formula

[vishu]

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

 

[blounty]

Hey there,

Ok heres an idea, try not using a vlookup but a sumif instead.

here it is:

=SUMIF(A1:A6,B25,B1:B6) A1:A6 is your employee ID Range on your dat
sheet, B25 is your employee ID you wish to reference, B1:B6 is amoun
range on your data sheet. this gives you 350.

hope this helps.

Any more help give me a shout.

Blount

 

[vishu]

hi blounty,
all my excel sheets contains VLOOK formula.
Is it possible in VLOOKUP function instead SUMIF forumla. Just I want to
know.

regards
vishu

 

[daddylonglegs]

VLOOKUP is designed to return a single value, SUMIF, as blounty says, i
definitely your best option here, it should be fairly simple to apply..