Ask Your Question
RSS
Sort by » date activity ▼ answers votes

38 questions

Tagged
  • ×
13
views
1
answer
no
votes
2019-01-03 00:35:38 +0100 SM_Riga flag of Latvia

Find previous occurrence of text in same column

46
views
1
answer
no
votes
2018-12-13 16:44:13 +0100 JohnSUN flag of Ukraine

Lookup() vs. Index() of Match()

59
views
1
answer
no
votes
2018-11-27 04:51:48 +0100 boo

VLOOKUP (or HLOOKUP, or LOOKUP) please help/suggest

225
views
3
answers
1
vote
2018-09-24 23:40:39 +0100 Regina flag of Germany

LOOKUP with linear interpolation for missing values

39
views
1
answer
no
votes
2018-06-03 18:36:25 +0100 SM_Riga flag of Latvia

Return a value in a row, based on two other rows

58
views
1
answer
no
votes
2018-03-06 19:36:52 +0100 erAck flag of Germany

Lookup formula assistance

114
views
1
answer
no
votes
2017-10-28 21:56:15 +0100 Lupp

Lookup for reference

711
views
2
answers
no
votes
2017-09-16 18:24:48 +0100 Jim K flag of United States of America

how to 'vlookup' on multiple critera

656
views
1
answer
no
votes
2017-04-17 01:48:27 +0100 Lupp

making a lookup table

118
views
2
answers
no
votes
2017-04-11 02:27:45 +0100 iperetta

CALC: How to lookup a formula instead of a value

135
views
2
answers
no
votes
2017-02-12 21:18:47 +0100 Lupp

Joining the results of a LOOKUP or VLOOKUP

372
views
2
answers
1
vote
2017-01-12 16:54:00 +0100 EasyTrieve

Form: Populate primary key from combobox value

64
views
no
answers
no
votes
2016-12-27 16:39:59 +0100 Barrier

Insert multiple rows from a query

67
views
2
answers
no
votes
2016-11-24 17:55:32 +0100 ZaferCelik

USING LOOKUPs but not working Libreoffice

34
views
1
answer
no
votes
2016-11-09 20:07:38 +0100 mark_t flag of Canada

calc - find value in subtable

537
views
2
answers
no
votes
2016-10-13 18:50:46 +0100 Lupp

Why is LOOKUP returning #NA in some fields but not others?

123
views
1
answer
no
votes
2016-03-13 02:31:13 +0100 m.a.riosv flag of Spain

Trying to use vlookup with indirect

614
views
2
answers
no
votes
2016-03-05 01:15:26 +0100 King_ZZ

Match data and EXTRACT cell ADDRESS

20
views
no
answers
no
votes
2016-02-20 04:17:09 +0100 gordon071

Does calc fail on some named reference formulas?

151
views
1
answer
no
votes
2016-02-10 17:43:44 +0100 XLgaming_inc flag of Netherlands

leaderboard in calc using =(H)LOOKUP() [closed]

199
views
3
answers
no
votes
2015-05-24 12:27:44 +0100 m.a.riosv flag of Spain

Error trying to lookup date range

592
views
1
answer
no
votes
2015-03-20 03:23:49 +0100 m.a.riosv flag of Spain

How do I lookup and return a most recent value?

Resources

Did you find this site useful? Support the LibreOffice community!

Contributors

XLgaming_inc gravatar imageRatslinger gravatar imagem.a.riosv gravatar imagekarolus gravatar imageJim K gravatar imageXoristzatziki gravatar imageJohnSUN gravatar imageEasyTrieve gravatar imageLupp gravatar imageendolith gravatar imageSM_Riga gravatar imageerAck gravatar imageKing_ZZ gravatar imageInopem gravatar imagepierre-yves samyn gravatar imagemanwenc gravatar image