Hi All,

Can anyone help me regarding the formula. Ive tried setting the column D with a if statement C6>=now() as not to show any values on time that hasn't occured yet but somehow the formula i set still shows all values.

This is the formula ive placed.
=IF(C6<=NOW(),VLOOKUP(B6,raw!A:D,4,0),"")

Please help me out.



Please see attached sample template.
formula test.xlsx