| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Problem with formulas
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,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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| problem with formulas | Excel Discussion (Misc queries) | |||
| problem with formulas (2) | Excel Discussion (Misc queries) | |||
| Two Formulas, and a problem with both..................... | Excel Discussion (Misc queries) | |||
| Copying formulas - problem with the sum | Excel Worksheet Functions | |||
| Problem with formulas | Excel Worksheet Functions | |||
Threaded Mode
