Compare two excel sheets in the same work book and merge data?

Dvij

New Member
Joined
Sep 17, 2011
Messages
2
Hi all I've two excel sheets in one work book,

Sheet 1 contains
A - S No
B - Mandal Name
C - DISE Code (Numbers are stored in this column)
D - Name of the School
E - Account No (This column is empty, we need to fill this column by the formula)

Sheet 2 contains
A - S No
B - Mandal Name
C - DISE Code (Numbers are stored in this column)
D - Name of the School
E - Account No (This column is filled with numbers, we need to put this data in column E of sheet 1, based on the condition that Column C i.e., DISE Code column in both sheets match, if they fail it should put false or message like school not found)

This is urgent please, I've to compare nearly 13,000 schools by tomorrow morning please help me urgently. I am still in office waiting for the solution.


& ifsc code in column c, column d is empty for account numbers

and sheet 2 contains school names in column b, account numbers in column c

Now sheet 1 is the master data.

What i want is if the school name in both sheets exist (they do exist as they are identical) the formula should copy account numbers to column d of sheet 1 (condition is that the school exists in both sheets, if it doesn't exist it should put false or something in that cell).

BTW, I am using MS-Office 2003
 

John Davis

Well-known Member
Joined
Sep 11, 2007
Messages
3,457
This might help with your first situation. Not sure I understand the second request. Change the ranges to suit.

=IF(ISNA(VLOOKUP(C2,Sheet2!$A$2:$E$7,3,FALSE)),"School Not Found",VLOOKUP(C2,Sheet2!$A$2:$E$7,3,FALSE))
 

Forum statistics

Threads
1,085,340
Messages
5,383,050
Members
401,813
Latest member
Lucy_Wood

Some videos you may like

This Week's Hot Topics

Top