=IF(ISNA(VLOOKUP(A1,New!$A$1:$I$2000,2,0)),"",VLOO KUP(A1,New!$A$1:$I$2000,2,0))

2 worksheets, same file. 2nd worksheet is call "New"

Sheet 1
ColA .... ColL
101 Above Formula for A1 (should be Mary)
102 Above Formula for A2 (should be Joe)
103 Above Formula for A3 (should be Fred)

Sheet 2 (called New)
ColA......ColB..... ColC
102 Joe etc...
103 Fred
101 Mary

This was working in my previous years file, but is not working in this years
file. Anyone see anything wrong?

Thanks!

FOUND THE PROBLEM!

Thanks anyway!