match values

Originally Posted by zbor

Try this in D1 and pull down:

=IF(ISNA(MATCH(C1,$A$1:$A$1000,0)),"",VLOOKUP(C1,$A$1:$B$1000,2,FALSE))

Doesn't work, Excel marks that something is wrong with the formula. It marks the C1,$A$1 values after MATCH of the formula.

I use excel 2007, if that has something to do with it. I also use english excel.