Never go wrong while looking for something
Never go wrong while looking for reference value When you are looking for something in a single row or column and like to reference the value from the same position in different row or column, there are number of options available to you in LibreCalc. You may try LOOKUP, HLOOKUP, VLOOKUP and OFFSET depending upon the use case, as each of them has certain requirement to be adhered while using them.