K
Kim
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 any error
or a simplier way.
=if(and(vlookup(a2,Sheet3!A:B,2,false)<=InDate,vlookup(a2,Sheet3!A:C,3,false)>=InDate,vlookup(a2,Sheet3!A,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,Sheet3!A:H,8,false)<=InDate,vlookup(a2,Sheet3!A:I,9,false)>=InDate,vlookup(a2,Sheet3!A:J,10,false),""))))
Thanks.
Kim
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 any error
or a simplier way.
=if(and(vlookup(a2,Sheet3!A:B,2,false)<=InDate,vlookup(a2,Sheet3!A:C,3,false)>=InDate,vlookup(a2,Sheet3!A,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,Sheet3!A:H,8,false)<=InDate,vlookup(a2,Sheet3!A:I,9,false)>=InDate,vlookup(a2,Sheet3!A:J,10,false),""))))
Thanks.
Kim