Hi,

To do what you want you need to lock the refrence cells using $.

sample =IF(VLOOKUP(C3, Sheet2!$A$3:$B$5, 2, FALSE) = "yes", A3*0.05, " ")

When you fill down the ref on sheet2 will not change.

Cheers

Tony