"snow" wrote:
....
Column A Column B Colum C
3256 1234 2541
2541 3256
1234
What formula do I write in Colum C to get if right?

Another play to try, using non-array formulas

Put in C1:
=IF(ISERROR(SMALL(E:E,ROW(A1))),"",
INDEX(A:A,MATCH(SMALL(E:E,ROW(A1)),E:E,0)))

Put in D1:
=IF(ISNUMBER(MATCH(A1,B:B,0)),"",ROW())

Select C1:D1, copy down until the last row of data in col A

Col C will return the required results all neatly bunched at the top
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---