|
How to change a cell color based on the name of the color
|
|
2
|
1143
|
December 10, 2019
|
|
Search criteria has 9E+100. What does it mean
|
|
2
|
1029
|
November 29, 2019
|
|
Lookup() vs. Index() of Match()
|
|
3
|
29628
|
October 31, 2019
|
|
lookup function between 2 files
|
|
4
|
2448
|
September 4, 2019
|
|
Pull data from long-form schedule to single day sheet
|
|
5
|
420
|
August 4, 2019
|
|
OpenOffice v LibreOffice Calc Function problem
|
|
11
|
836
|
April 15, 2019
|
|
Calc VLOOKUP - enter FALSE as the last parameter
|
|
1
|
1159
|
February 13, 2019
|
|
Calc - Obtener una lista de valores.
|
|
1
|
907
|
December 21, 2018
|
|
LOOKUP with nested ISTEXT/ISNUMBER/ISBLANK returns a different value than expected (compared to Excel)
|
|
5
|
707
|
December 21, 2018
|
|
VLOOKUP (or HLOOKUP, or LOOKUP) please help/suggest
|
|
6
|
2582
|
November 27, 2018
|
|
find value in matrix (in other words: find value based on 2 criteria)
|
|
2
|
716
|
October 8, 2018
|
|
Lookup by column and row values
|
|
3
|
15881
|
July 31, 2021
|
|
How to do this special lookup in external file?
|
|
9
|
1879
|
July 31, 2021
|
|
Suchrahmen beibehalten beim Nach-Unten-Ziehen einer Formel
|
|
1
|
330
|
June 8, 2018
|
|
Return a value in a row, based on two other rows
|
|
4
|
1211
|
July 31, 2021
|
|
Spalte aus 2. Sheet in 1. mergen (VLOOKUP)
|
|
2
|
669
|
May 29, 2018
|
|
Lookup formula assistance
|
|
4
|
724
|
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
|
5007
|
July 31, 2021
|
|
Lookup matching regular expression in Calc
|
|
8
|
7788
|
July 31, 2021
|
|
Lookup for reference
|
|
3
|
414
|
July 31, 2021
|
|
How to 'vlookup' on multiple criteria
|
|
7
|
7096
|
July 31, 2021
|
|
Is there a look-up dictionary for LibreOffice NOT a thesaurus?
|
|
1
|
381
|
July 31, 2021
|
|
Making a lookup table
|
|
2
|
3720
|
July 31, 2021
|
|
CALC: How to lookup a formula instead of a value
|
|
8
|
1111
|
July 31, 2021
|
|
Joining the results of a LOOKUP or VLOOKUP
|
|
4
|
1272
|
July 31, 2021
|
|
Form: Populate primary key from combobox value
|
|
4
|
1757
|
July 31, 2021
|
|
Insert multiple rows from a query
|
|
1
|
270
|
July 31, 2021
|
|
USING LOOKUPs but not working Libreoffice
|
|
3
|
690
|
July 31, 2021
|
|
Calc - find value in subtable
|
|
5
|
984
|
July 31, 2021
|
|
Why is LOOKUP returning #NA in some fields but not others?
|
|
9
|
3900
|
July 31, 2021
|
