Vlookup - when there might be more then one line

[gails58]

I am do a compare of two different spreadsheets, it is working fine, except in cases when the employee has more than one line of data. I want it to add each line together to give me a total. is that possible? For example, I am comparing labor amounts to payroll amounts, so if they charged all time to one code, the vlookup works fine, but if they charged more then 1 code then I am having issues. Any way to get this to work?

 

[Fluff]

Hi & welcome to MrExcel.
Can you post some sample data from both sheets, showing expected results.

MrExcel has a tool called “XL2BB” that lets you post samples of your data that will allow us to copy/paste it to our Excel spreadsheets, so we can work with the same copy of data that you are. Instructions on using this tool can be found here: XL2BB Add-in

Note that there is also a "Test Here” forum on this board. This is a place where you can test using this tool (or any other posting techniques that you want to test) before trying to use those tools in your actual posts.

 

[gails58]

Unfortunately, my work computer will not allow me to download this add in. An example would be like as follows:
Sheet 1

10000315	PD LEAVE	0.250​	7.880​
	Regular	87.750​	2,766.760​

Sheet 2

10000315	Regular	87.75	31.53	2,766.76
	Paid leave	0.25	31.53	7.88

Sheet 3 is my combination sheet using a vlookup
it pulls the number and the first line. They don't match, as they aren't in the same order and even if they were, they aren't the total. So if all they have is regular hours, it works fine, it is one line. How do I do this to have it include all the lines?

 

[Fluff]

Is the number only on the first line of data, or is it on every line?

 

[gails58]

I can get the employee number on every line, if that helps.

 

[Fluff]

Ok, is this what you want

+Fluff 1.xlsm
	A	B	C	D
1
2	10000315	PD LEAVE	0.25	7.88
3	10000315	Regular	87.75	2,766.76
Sheet1

+Fluff 1.xlsm
	A	B
1
2	10000315	88
Sheet2

Cell Formulas
Range	Formula
B2	B2	=SUM(FILTER(Sheet1!C2:C100,Sheet1!A2:A100=A2))

 

[gails58]

Thank you!!

 

[Fluff]

You're welcome & thanks for the feedback.