brilliant, many thanks, you make my day.

chris90

"vezerid" wrote:

In worksheet2!D1:
=if(isna(vlookup(C1, worksheet1!$A$1:$B$10, 2, 0)), "", vlookup(C1,
worksheet1!$A$1:$B$10, 2, 0))

HTH
Kostis Vezerides