It seem you have not added a closing parenthesis for each AND
=if(
and(vlookup(a2,Sheet3!A:B,2,false)<=InDate,vlookup (a2,Sheet3!A:C,3,false)=InDate),vlookup(a2,Sheet3 !A:D,4,false),if(and(vlookup(a2,Sheet3!A:E,5,false )<=Indate,vlookup(a2,Sheet3!A:F,6,false)=InDate), vlookup(a2,Sheet3!A:G,7,false),if(and(vlookup(a2,S heet3!A:H,8,false)<=InDate,vlookup(a2,Sheet3!A:I,9 ,false)=InDate),vlookup(a2,Sheet3!A:J,10,false)," "))))but then again, since the formula is no in caps, you clearly did not copyand paste from the worksheet so this could be a typo only in your email--Bernard V LiengmeMicrosoft Excel MVPhttp://people.stfx.ca/bliengmeremove caps from email"Kim" wrote in ... Hi, I've a problem with below formula. I've check a few time and it should be correct. Could someone please check and let me know if they know of anyerror or a simplier way.=if(and(vlookup(a2,Sheet3!A:B,2,false)<=InDa te,vlookup(a2,Sheet3!A:C,3,false)=InDate,vlookup( a2,Sheet3!A:D,4,false),if(and(vlookup(a2,Sheet3!A: E,5,false)<=Indate,vlookup(a2,Sheet3!A:F,6,false) =InDate,vlookup(a2,Sheet3!A:G,7,false),if(and(vloo kup(a2,Sheet3!A:H,8,false)<=InDate,vlookup(a2,Shee t3!A:I,9,false)=InDate,vlookup(a2,Sheet3!A:J,10,f alse),"")))) Thanks. Kim