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

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 data
sheet, B25 is your employee ID you wish to reference, B1:B6 is amount
range on your data sheet. this gives you 350.

hope this helps.

Any more help give me a shout.

Blounty


--
blounty
------------------------------------------------------------------------
blounty's Profile: http://www.excelforum.com/member.php...o&userid=32632
View this thread: http://www.excelforum.com/showthread...hreadid=524384

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

"blounty" wrote:


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 data
sheet, B25 is your employee ID you wish to reference, B1:B6 is amount
range on your data sheet. this gives you 350.

hope this helps.

Any more help give me a shout.

Blounty


--
blounty
------------------------------------------------------------------------
blounty's Profile: http://www.excelforum.com/member.php...o&userid=32632
View this thread: http://www.excelforum.com/showthread...hreadid=524384

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


--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486
View this thread: http://www.excelforum.com/showthread...hreadid=524384