![]() ![]() So, if I chunk up the formula into each of its parts: When I run this formula, OpenOffice returns the error #DIV/0!. ![]() Hereby changing the sheetname from Import!$F$ to $Import.$F$. ![]() I found that the way OpenOffice Calc accesses a range from another sheet is different to how Excel does, hence I rewrote the formula to: =LOOKUP(2 1/(INDIRECT(CONCATENATE("$Import.$F$" Q3 ":$F$" M3))>=(S3)*VALUE(SUBSTITUTE($S$1 "LOOKUP FACTOR x" ""))) INDIRECT(CONCATENATE("$Import.$B$" Q3 ":$B$" M3))) if is LOOKUP FACTOR x2, the value in S3 is multiplied by 2. I want to return the last value in a specific range (and match its row in another range) that is greater than or equal to the value in S3 multiplied by the LOOKUP FACTOR x, e.g. This formula is quite long to some extent, but to keep it short I have 2 sheets, one called Import and the other Lookup. I recently converted a file named template.xlsx into template.ods using the command line utility called gnumeric. ![]()
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |