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

31 questions

Tagged
  • ×
  • ×
105
views
3
answers
1
vote
2018-09-24 23:40:39 +0100 Regina flag of Germany

LOOKUP with linear interpolation for missing values

34
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

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

Lookup formula assistance

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

Lookup for reference

565
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

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

making a lookup table

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

CALC: How to lookup a formula instead of a value

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

Joining the results of a LOOKUP or VLOOKUP

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

Insert multiple rows from a query

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

USING LOOKUPs but not working Libreoffice

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

calc - find value in subtable

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

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

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

Trying to use vlookup with indirect

509
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?

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

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

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

Error trying to lookup date range

559
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?

4k
views
1
answer
2
votes
2014-01-29 22:09:24 +0100 hunteke

Lookup matching regular expression in Calc [closed]

Resources

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

Contributors

karolus gravatar imageXLgaming_inc gravatar imageJim K gravatar imagem.a.riosv gravatar imageM_Bison gravatar imageXoristzatziki gravatar imageROSt52 gravatar imageLupp gravatar imageerAck gravatar imagePedro gravatar imageSM_Riga gravatar imageendolith gravatar imageKing_ZZ gravatar imageRegina gravatar imageMike Kaganski gravatar imagecaliray gravatar image