Help with a formula
see reply to your other posting
--
Regards
Roger Govier
"Kim" wrote in message
...
Hi,
I've a problem with a formula. I've check a few time but still cant see
what's wrong with the formula. Could someone please have a look if I miss
out
something.
=if(and(vlookup(a2,Sheet3!A:B,2,false)<=InDate,vlo okup(a2,Sheet3!A:C,3,false)=InDate,vlookup(a2,She et3!A:D,4,false),if(and(vlookup(a2,Sheet3!A:E,5,fa lse)<=Indate,vlookup(a2,Sheet3!A:F,6,false)=InDat e,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
|