comparin two excels

October 25, 2011 at 09:49:55
Specs: Windows 7
I am having master list of all employees. On monthly basis i will get invoice which contains name and fess for various services. Please let me know the formula which can compare names from invoice with master list and return fees amount in the column.

eg:
Invoice sheet

Name fees1 fees2 fees3
XYZ 10 30
abc 5 15 100
asd 2


Expecting result

xyz xyz 10 30
abc abc 5 15 100
asd asd 2



See More: comparin two excels

Report •


#1
October 25, 2011 at 11:57:43
Why do you want to duplicate the name in the results?

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •

#2
October 26, 2011 at 10:46:36
hi derby,
Sorry that is invoice no.

Name are repeating in invoices (i am having different invoices in which they have charged fees). So in one row i need all the fees charged to that particular individual.

And i have to check any fees charged twice for that individual.



Report •

#3
October 26, 2011 at 12:12:52
I'm still confused.

Please click on the blue line at the bottom of this post and read the instructions found via that link.

Then repost your data so that we can tell what data is in which column.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •

Related Solutions

#4
November 9, 2011 at 08:33:32
Invoice sheet is like
Name	Passport No					GL #	Date	FEES1	FEES2	FEES3	FEES4	FEES5	FEES6	FEES7	FEES8	FEES8	FEES9	FEES10	Grand Total
ABC	761241349	761241349	CSS	A011		12009003	3-Jul-11										200		200
ABC	761241349	761241349	CSS	A011		12009003	4-Jul-11								1500				1500
ABC	761241349	761241349	CSS	A011		12009003	6-Jul-11						240						240
XYZ	108538359	108538359	CSS	CC026		12009003	17-Jul-11										200		200
XYZ	108538359	108538359	CSS	CC026		12009003	18-Jul-11								1500				1500
<pre>
Master file looks like below
S.NO. NAME Passport no NATIONALITY FEES1 FEES2 FEES3 FEES4 FEES5 FEES6 FEES7 FEES8 FEES9 FEES10 Grand Total
1 ABC 1 1 1
2 XYZ 1 1 1
3 ASD
4 FGH 1
5 TVS 1 1
6 LMN

In master file we have to check whether any fees have charged twice.

Presently we are applying vlookup to check all names belongs to us then by name we are checking in master file and puting 1 against fees no.


Report •


Ask Question