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

40 questions

Tagged
  • ×
26
views
1
answer
1
vote
2019-08-05 01:58:47 +0200 Lupp

Pull data from long-form schedule to single day sheet

78
views
2
answers
no
votes
2019-04-13 00:18:24 +0200 Neil Grantham

OpenOffice v LibreOffice Calc Function problem

53
views
1
answer
no
votes
2019-02-13 13:51:04 +0200 Mike Kaganski flag of Russia

Calc VLOOKUP - enter FALSE as the last parameter

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

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

189
views
1
answer
no
votes
2018-11-27 04:51:48 +0200 boo

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

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

LOOKUP with linear interpolation for missing values

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

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

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

Lookup formula assistance

126
views
1
answer
no
votes
2017-10-28 21:56:15 +0200 Lupp

Lookup for reference

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

how to 'vlookup' on multiple critera

890
views
1
answer
no
votes
2017-04-17 01:48:27 +0200 Lupp

making a lookup table

177
views
2
answers
no
votes
2017-04-11 02:27:45 +0200 iperetta

CALC: How to lookup a formula instead of a value

177
views
2
answers
no
votes
2017-02-12 21:18:47 +0200 Lupp

Joining the results of a LOOKUP or VLOOKUP

545
views
2
answers
1
vote
2017-01-12 16:54:00 +0200 EasyTrieve

Form: Populate primary key from combobox value

75
views
no
answers
no
votes
2016-12-27 16:39:59 +0200 Barrier

Insert multiple rows from a query

85
views
2
answers
no
votes
2016-11-24 17:55:32 +0200 ZaferCelik

USING LOOKUPs but not working Libreoffice

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

calc - find value in subtable

910
views
2
answers
no
votes
2016-10-13 18:50:46 +0200 Lupp

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

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

Trying to use vlookup with indirect

916
views
2
answers
no
votes
2016-03-05 01:15:26 +0200 King_ZZ

Match data and EXTRACT cell ADDRESS

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

Does calc fail on some named reference formulas?

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

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

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

Error trying to lookup date range

683
views
1
answer
no
votes
2015-03-20 03:23:49 +0200 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

Jim K gravatar imageJohnSUN gravatar imageXoristzatziki gravatar imageXLgaming_inc gravatar imagem.a.riosv gravatar imageD.C.Ballard gravatar imageEasyTrieve gravatar imageLupp gravatar imagekarolus gravatar imageRatslinger gravatar imageerAck gravatar imageSM_Riga gravatar imageKing_ZZ gravatar imageendolith gravatar imageVitaly gravatar imagemark.simpson.3572 gravatar image