Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Named Range
Date 1 2 3 4 5 6 7 8 ...ect..
Employee NameRecord * <-formula in every column with 1 digit result * =IF(ISNA(AND(takeoff<=G$86,takeoff=$G$86,$B87<"" )),"",IF(AND(takeoff<=G$86,takeoff=$G$86),"",IF(I SNA(VLOOKUP($B87&G$86&$F87,ReqOff,3,FALSE)),IF(ISO DD(G$84),IF(VLOOKUP(first_name,staff_data,FSOS+G$8 3,FALSE)=0,"",VLOOKUP(first_name,staff_data,FSOS+G $83,FALSE)),IF(VLOOKUP(first_name,staff_data,FSES+ G$83,FALSE)=0,"",VLOOKUP(first_name,staff_data,FSE S+G$83,FALSE))),IF(VLOOKUP(first_name&G$86&$F87,Re qOff,4,FALSE)=0,"",VLOOKUP(first_name&G$86&$F87,Re qOff,4,FALSE))))) G$86 = Date G$83 = Week Number $B87 = Current Shift That is the formula I am using. Right now it is working relatively okay, it tends to freak out when I edit it in 2007 while using compatability mode 97-2003. So the question here is....how can I replace $G$86 with a named range that will fill across the month. I really need to shorten some of the formula...I think that will help. Thanks alot for helping me Scottie |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Referencing a named range based upon Range name entry in cell | Excel Worksheet Functions | |||
automatic range - named range give me circular reference... | Excel Discussion (Misc queries) | |||
Array as a "named range" - formula ok in cells, but error as "named range" | Excel Discussion (Misc queries) | |||
inserting a named range into new cells based on a named cell | Excel Discussion (Misc queries) | |||
Cannot Expand Named Range - when size of the Range exceeds | Excel Discussion (Misc queries) |