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

It' very difficult to resolve your formula and guess your goal. Please post
data layout and put the job in plain text!
Regards,
Stefi

€žKim€� ezt Ã*rta:

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

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