| 
            
            
            
            
              Save data from Calc invoice template to separate sheet
            
            
           | 
          
              
                 
              
              
                 
              
              
                 
              
              
                 
              
           | 
          
            5
           | 
          
            2211
           | 
          
            April 1, 2025
           | 
        
        
          | 
            
            
              
            
            
              LOOKUP with linear interpolation for missing values
            
            
           | 
          
              
                 
              
              
                 
              
              
                 
              
              
                 
              
              
                 
              
           | 
          
            14
           | 
          
            11118
           | 
          
            February 19, 2025
           | 
        
        
          | 
            
            
            
            
              Libre Calc: SUM where the criteria are comma-delimited values but in a single cell
            
            
           | 
          
              
                 
              
              
                 
              
              
                 
              
              
                 
              
           | 
          
            6
           | 
          
            1358
           | 
          
            July 26, 2024
           | 
        
        
          | 
            
            
            
            
              XLOOKUP from lox365 returns rows but not columns. Why?
            
            
           | 
          
              
                 
              
              
                 
              
              
                 
              
           | 
          
            2
           | 
          
            1055
           | 
          
            June 2, 2024
           | 
        
        
          | 
            
            
            
            
              In Calc, lookup values in date ranges by start date
            
            
           | 
          
              
                 
              
              
                 
              
              
                 
              
              
                 
              
              
                 
              
           | 
          
            12
           | 
          
            4294
           | 
          
            May 14, 2024
           | 
        
        
          | 
            
            
            
            
              Combine SUM and LOOKUP across multiple sheets
            
            
           | 
          
              
                 
              
              
                 
              
           | 
          
            1
           | 
          
            891
           | 
          
            May 7, 2024
           | 
        
        
          | 
            
            
            
            
              What string > "Z"? (Or, string comparison defined?)
            
            
           | 
          
              
                 
              
              
                 
              
              
                 
              
              
                 
              
           | 
          
            14
           | 
          
            2750
           | 
          
            August 8, 2022
           | 
        
        
          | 
            
            
            
            
              Lookup with more than one criteria + suggestion of possible values
            
            
           | 
          
              
                 
              
              
                 
              
           | 
          
            5
           | 
          
            1604
           | 
          
            December 15, 2021
           | 
        
        
          | 
            
            
            
            
              Lookup matching regular expression in Calc - Addition
            
            
           | 
          
              
                 
              
              
                 
              
              
                 
              
              
                 
              
           | 
          
            6
           | 
          
            2883
           | 
          
            December 14, 2021
           | 
        
        
          | 
            
            
            
            
              debugging LOOKUP()
            
            
           | 
          
              
                 
              
              
                 
              
              
                 
              
              
                 
              
              
                 
              
           | 
          
            12
           | 
          
            3215
           | 
          
            November 17, 2021
           | 
        
        
          | 
            
            
            
            
              Can a hyperlink / button take me to specific looked-up value in range
            
            
           | 
          
              
                 
              
              
                 
              
              
                 
              
           | 
          
            9
           | 
          
            1170
           | 
          
            June 25, 2021
           | 
        
        
          | 
            
            
            
            
              Reverse hlookup
            
            
           | 
          
              
                 
              
              
                 
              
              
                 
              
              
                 
              
           | 
          
            5
           | 
          
            1787
           | 
          
            June 9, 2021
           | 
        
        
          | 
            
            
            
            
              Efficacy of storing text or referring to text
            
            
           | 
          
              
                 
              
              
                 
              
              
                 
              
           | 
          
            4
           | 
          
            1160
           | 
          
            April 24, 2021
           | 
        
        
          | 
            
            
            
            
              Base form sort on lookup value, not key value?
            
            
           | 
          
              
                 
              
              
                 
              
           | 
          
            3
           | 
          
            1824
           | 
          
            April 11, 2021
           | 
        
        
          | 
            
            
            
            
              LOOKUP picks data from unreferenced sheet
            
            
           | 
          
              
                 
              
              
                 
              
              
                 
              
              
                 
              
              
                 
              
           | 
          
            6
           | 
          
            1288
           | 
          
            March 15, 2021
           | 
        
        
          | 
            
            
              
            
            
              How to lookup a column with multiple exact match results and find a value in the next column higher or equal to a calculated formula?
            
            
           | 
          
              
                 
              
              
                 
              
              
                 
              
           | 
          
            8
           | 
          
            5239
           | 
          
            February 7, 2021
           | 
        
        
          | 
            
            
            
            
              Use Column() in vlookup as indicators what range columns to display.
            
            
           | 
          
              
                 
              
              
                 
              
              
                 
              
           | 
          
            5
           | 
          
            2003
           | 
          
            January 14, 2021
           | 
        
        
          | 
            
            
            
            
              Range lookup in Calc?
            
            
           | 
          
              
                 
              
              
                 
              
           | 
          
            1
           | 
          
            4773
           | 
          
            January 6, 2021
           | 
        
        
          | 
            
            
            
            
              How to lookup the first non '0' number in a list?
            
            
           | 
          
              
                 
              
              
                 
              
           | 
          
            2
           | 
          
            1273
           | 
          
            December 16, 2020
           | 
        
        
          | 
            
            
            
            
              Trying to find Smallest in a list and show date and value
            
            
           | 
          
              
                 
              
              
                 
              
              
                 
              
              
                 
              
           | 
          
            8
           | 
          
            1904
           | 
          
            December 12, 2020
           | 
        
        
          | 
            
            
            
            
              How to reference a cell in Google Sheets from Libre CALC
            
            
           | 
          
              
                 
              
              
                 
              
           | 
          
            2
           | 
          
            1870
           | 
          
            December 1, 2020
           | 
        
        
          | 
            
            
              
            
            
              Lookup question?
            
            
           | 
          
              
                 
              
              
                 
              
              
                 
              
              
                 
              
           | 
          
            7
           | 
          
            846
           | 
          
            August 1, 2021
           | 
        
        
          | 
            
            
            
            
              Lookup smallest in column
            
            
           | 
          
              
                 
              
              
                 
              
           | 
          
            6
           | 
          
            897
           | 
          
            August 1, 2021
           | 
        
        
          | 
            
            
            
            
              look up value from contents of list
            
            
           | 
          
              
                 
              
              
                 
              
              
                 
              
              
                 
              
              
                 
              
           | 
          
            7
           | 
          
            1074
           | 
          
            August 27, 2020
           | 
        
        
          | 
            
            
            
            
              add combo box to Base table field
            
            
           | 
          
              
                 
              
              
                 
              
           | 
          
            1
           | 
          
            1644
           | 
          
            August 12, 2020
           | 
        
        
          | 
            
            
            
            
              Help reaching the last match
            
            
           | 
          
              
                 
              
              
                 
              
              
                 
              
           | 
          
            4
           | 
          
            2147
           | 
          
            August 1, 2021
           | 
        
        
          | 
            
            
            
            
              Return the last value in a column
            
            
           | 
          
              
                 
              
              
                 
              
              
                 
              
              
                 
              
           | 
          
            8
           | 
          
            19425
           | 
          
            August 1, 2021
           | 
        
        
          | 
            
            
              
            
            
              Lookup Part of Text: Randomly Placed Text in Cell
            
            
           | 
          
              
                 
              
              
                 
              
              
                 
              
           | 
          
            15
           | 
          
            3282
           | 
          
            August 1, 2021
           | 
        
        
          | 
            
            
            
            
              Run Time Error for Record not found in Macro SQL
            
            
           | 
          
              
                 
              
              
                 
              
           | 
          
            11
           | 
          
            1932
           | 
          
            April 10, 2020
           | 
        
        
          | 
            
            
            
            
              Lookup data from different sheet
            
            
           | 
          
              
                 
              
              
                 
              
              
                 
              
           | 
          
            4
           | 
          
            14412
           | 
          
            March 7, 2020
           |