|
Search criteria has 9E+100. What does it mean
|
|
2
|
527
|
November 29, 2019
|
|
Lookup() vs. Index() of Match()
|
|
3
|
23597
|
October 31, 2019
|
|
lookup function between 2 files
|
|
4
|
1708
|
September 4, 2019
|
|
Pull data from long-form schedule to single day sheet
|
|
5
|
230
|
August 4, 2019
|
|
OpenOffice v LibreOffice Calc Function problem
|
|
11
|
500
|
April 15, 2019
|
|
Calc VLOOKUP - enter FALSE as the last parameter
|
|
1
|
766
|
February 13, 2019
|
|
Calc - Obtener una lista de valores.
|
|
1
|
495
|
December 21, 2018
|
|
LOOKUP with nested ISTEXT/ISNUMBER/ISBLANK returns a different value than expected (compared to Excel)
|
|
5
|
497
|
December 21, 2018
|
|
VLOOKUP (or HLOOKUP, or LOOKUP) please help/suggest
|
|
6
|
1987
|
November 27, 2018
|
|
find value in matrix (in other words: find value based on 2 criteria)
|
|
2
|
451
|
October 8, 2018
|
|
Lookup by column and row values
|
|
3
|
12773
|
July 31, 2021
|
|
How to do this special lookup in external file?
|
|
9
|
1328
|
July 31, 2021
|
|
Suchrahmen beibehalten beim Nach-Unten-Ziehen einer Formel
|
|
1
|
188
|
June 8, 2018
|
|
Return a value in a row, based on two other rows
|
|
4
|
629
|
July 31, 2021
|
|
Spalte aus 2. Sheet in 1. mergen (VLOOKUP)
|
|
2
|
362
|
May 29, 2018
|
|
Lookup formula assistance
|
|
4
|
386
|
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
|
4444
|
July 31, 2021
|
|
Lookup matching regular expression in Calc
|
|
8
|
7134
|
July 31, 2021
|
|
Lookup for reference
|
|
3
|
277
|
July 31, 2021
|
|
How to 'vlookup' on multiple criteria
|
|
7
|
5477
|
July 31, 2021
|
|
Is there a look-up dictionary for LibreOffice NOT a thesaurus?
|
|
1
|
251
|
July 31, 2021
|
|
Making a lookup table
|
|
2
|
2811
|
July 31, 2021
|
|
CALC: How to lookup a formula instead of a value
|
|
8
|
635
|
July 31, 2021
|
|
Joining the results of a LOOKUP or VLOOKUP
|
|
4
|
852
|
July 31, 2021
|
|
Form: Populate primary key from combobox value
|
|
4
|
1281
|
July 31, 2021
|
|
Insert multiple rows from a query
|
|
1
|
180
|
July 31, 2021
|
|
USING LOOKUPs but not working Libreoffice
|
|
3
|
477
|
July 31, 2021
|
|
Calc - find value in subtable
|
|
5
|
630
|
July 31, 2021
|
|
Why is LOOKUP returning #NA in some fields but not others?
|
|
9
|
3132
|
July 31, 2021
|
|
Trying to use vlookup with indirect
|
|
2
|
467
|
July 31, 2021
|
