Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I am looking for a whay to shorten/improve/optimize this formula. I just
dont' want it to be such a pain to update if needed. It is larely repetitive. =IF(ISERROR(SUM(VLOOKUP(INDIRECT("L"&ROW()),Data!$ J$2:$O$7,6,FALSE),(VLOOKUP(INDIRECT("M"&ROW()),Dat a!$I$2:$O$7,7,FALSE)),(VLOOKUP(INDIRECT("N"&ROW()) ,Data!$I$2:$O$7,7,FALSE)),(VLOOKUP(INDIRECT("O"&RO W()),Data!$L$2:$O$7,4,FALSE)),(VLOOKUP(INDIRECT("P "&ROW()),Data!$I$2:$O$7,7,FALSE)),(VLOOKUP(INDIREC T("Q"&ROW()),Data!$I$2:$O$7,7,FALSE)),(VLOOKUP(IND IRECT("R"&ROW()),Data!$I$2:$O$7,7,FALSE)),(VLOOKUP (INDIRECT("S"&ROW()),Data!$I$2:$O$7,7,FALSE)))),"" ,SUM(VLOOKUP(INDIRECT("L"&ROW()),Data!$J$2:$O$7,6, FALSE),(VLOOKUP(INDIRECT("M"&ROW()),Data!$I$2:$O$7 ,7,FALSE)),(VLOOKUP(INDIRECT("N"&ROW()),Data!$I$2: $O$7,7,FALSE)),(VLOOKUP(INDIRECT("O"&ROW()),Data!$ L$2:$O$7,4,FALSE)),(VLOOKUP(INDIRECT("P"&ROW()),Da ta!$I$2:$O$7,7,FALSE)),(VLOOKUP(INDIRECT("Q"&ROW() ),Data!$I$2:$O$7,7,FALSE)),(VLOOKUP(INDIRECT("R"&R OW()),Data!$I$2:$O$7,7,FALSE)),(VLOOKUP(INDIRECT(" S"&ROW()),Data!$I$2:$O$7,7,FALSE)))) Thank you! -- Thank you, Gregory |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Any way to shorten this up? | Excel Worksheet Functions | |||
Shorten a Formula | Excel Worksheet Functions | |||
Shorten an IF formula | Excel Discussion (Misc queries) | |||
shorten formula | Excel Worksheet Functions | |||
Shorten A Name | Excel Discussion (Misc queries) |