|
Base Lookup
|
|
7
|
2860
|
July 31, 2021
|
|
Calculate averages from several data ranges
|
|
5
|
4698
|
January 26, 2020
|
|
How to change a cell color based on the name of the color
|
|
2
|
2226
|
December 10, 2019
|
|
Search criteria has 9E+100. What does it mean
|
|
2
|
2491
|
November 29, 2019
|
|
Lookup() vs. Index() of Match()
|
|
3
|
42633
|
October 31, 2019
|
|
lookup function between 2 files
|
|
4
|
3749
|
September 4, 2019
|
|
Pull data from long-form schedule to single day sheet
|
|
5
|
1119
|
August 4, 2019
|
|
OpenOffice v LibreOffice Calc Function problem
|
|
11
|
2120
|
April 15, 2019
|
|
Calc VLOOKUP - enter FALSE as the last parameter
|
|
1
|
1987
|
February 13, 2019
|
|
Calc - Obtener una lista de valores.
|
|
1
|
2026
|
December 21, 2018
|
|
LOOKUP with nested ISTEXT/ISNUMBER/ISBLANK returns a different value than expected (compared to Excel)
|
|
5
|
1545
|
December 21, 2018
|
|
VLOOKUP (or HLOOKUP, or LOOKUP) please help/suggest
|
|
6
|
4279
|
November 27, 2018
|
|
find value in matrix (in other words: find value based on 2 criteria)
|
|
2
|
1456
|
October 8, 2018
|
|
Lookup by column and row values
|
|
3
|
19350
|
July 31, 2021
|
|
How to do this special lookup in external file?
|
|
9
|
3782
|
July 31, 2021
|
|
Suchrahmen beibehalten beim Nach-Unten-Ziehen einer Formel
|
|
1
|
882
|
June 8, 2018
|
|
Return a value in a row, based on two other rows
|
|
4
|
2548
|
July 31, 2021
|
|
Spalte aus 2. Sheet in 1. mergen (VLOOKUP)
|
|
2
|
1442
|
May 29, 2018
|
|
Lookup formula assistance
|
|
4
|
1400
|
July 31, 2021
|
|
I am trying to match the last non blank cell in a row with the header above it. I used this formula in Excel, =LOOKUP(2,1/(L2:R2<>""),M$1:S$1) but its not working in LibreOffice. Any suggestions?
|
|
10
|
7398
|
July 31, 2021
|
|
Lookup matching regular expression in Calc
|
|
8
|
9869
|
July 31, 2021
|
|
Lookup for reference
|
|
3
|
839
|
July 31, 2021
|
|
How to 'vlookup' on multiple criteria
|
|
7
|
10026
|
July 31, 2021
|
|
Is there a look-up dictionary for LibreOffice NOT a thesaurus?
|
|
1
|
727
|
July 31, 2021
|
|
Making a lookup table
|
|
2
|
5412
|
July 31, 2021
|
|
CALC: How to lookup a formula instead of a value
|
|
8
|
2349
|
July 31, 2021
|
|
Joining the results of a LOOKUP or VLOOKUP
|
|
4
|
2206
|
July 31, 2021
|
|
Form: Populate primary key from combobox value
|
|
4
|
2914
|
July 31, 2021
|
|
Insert multiple rows from a query
|
|
1
|
440
|
July 31, 2021
|
|
USING LOOKUPs but not working Libreoffice
|
|
3
|
1683
|
July 31, 2021
|
