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

[Dvij]

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]

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))