I've looked through the posts and tried several suggestions but I can't seem
to get it right - and can't figure out why it's not working.

My data is on two sheets, both contain the following columns: Org, Area,
Name. One sheet is the most recent listing. The other sheet is the old
stuff.

I need to compare the new listing to the old and find any changes. Changes
could be a brand new Org/Area or a name change.

New listing example:

Org Area Name
0 0 Headquarters
0 1 Corporate
0 2 South Campus
0 3 North Campus

Old listing example:

Org Area Name
0 0 Main Office
0 1 Corporate Facility
0 3 North Campus

So there are 2 changes and one new record.

I created a column in the New listing sheet called Old Name and used the
following formula:

=LOOKUP(2,1/(($A$2:$A$26=Old!$A2)*($B$2:$B$26=Old!$B2)),Old!$C $2:Old!$C$26)

Did the CTRL/SHIFT/ENTER to make sure it was set right. Then I copied the
formula down to the other 3 cells.

My results we

Old Name
0
Corporate Facility
0
0

I don't understand why it worked for ONE row and not any of the others??

Help?