to sum the data match in two files by using Vlookup

[miss Niki]

Hi all..

i have two excel files which are data and master..both files will be use for salary calculating.. the vlookup formula will be use in master files for dragging the salary data from Data files..the formula as follow
VLOOKUP(B4:B225,'D:\Salary\[Data.xls]AUG'!A$1:F$65536,6,FALSE))

the vlookup working fine to me.. but my problems is i want the data to be auto calculated when they have same value in two columns.. or if the name is similar/match in two columns (one for salary and another one for overtime), the salary should be auto calculated.

Data files will contain of these:
a:Employee ID
b:employee name
c:Employee salary/Overtime
[TABLE="width: 516"]
<TBODY>[TR]
[TD]</SPAN>Master files will contain of these:
a:Employee ID
b:Emplyee Name
c:Employee Nett Salary (that will be dragging from Data files)

is there any formula that i can used to combined with my vlookup formula?

appreciate any help! thanks!!
[TABLE="width: 516"]
<TBODY>[TR]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[TD] [/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</TBODY><COLGROUP><COL><COL><COL><COL><COL><COL></COLGROUP>[/TABLE]
[/TD]
[TD][/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD][/TD]
[/TR]
</TBODY><COLGROUP><COL><COL><COL><COL><COL><COL></COLGROUP>[/TABLE]
[TABLE="width: 516"]
<TBODY>[TR]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]</SPAN>[/TD]
[/TR]
</TBODY><COLGROUP><COL><COL><COL><COL><COL><COL></COLGROUP>[/TABLE]

 

[miss Niki]

wowwww..u r genius! it solved my problem..really appreciated it!

 

[bschwartz]

Thanks for the kind words. I'm glad it helped.

Cheers

​

 

[miss Niki]

really appreciated it...

 

[miss Niki]

anyway ben..may i know why u didn't use VLOOKUP?

 

[bschwartz]

Of course you can.

We could not use VLOOKUP because VLOOKUP only returns one value. In this case, we needed to sum all of the values based on a specific criteria.

Hope that helps...

 

[miss Niki]

okie..that's clear enough...thank you!