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

38 questions

Tagged
  • ×
32
views
1
answer
no
votes
2019-02-13 13:51:04 +0100 Mike Kaganski flag of Russia

Calc VLOOKUP - enter FALSE as the last parameter

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

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

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

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

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

LOOKUP with linear interpolation for missing values

41
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

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

Lookup formula assistance

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

Lookup for reference

864
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

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

making a lookup table

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

CALC: How to lookup a formula instead of a value

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

Joining the results of a LOOKUP or VLOOKUP

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

Form: Populate primary key from combobox value

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

Insert multiple rows from a query

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

USING LOOKUPs but not working Libreoffice

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

calc - find value in subtable

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

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

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

Trying to use vlookup with indirect

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

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

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

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

Error trying to lookup date range

627
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

JohnSUN gravatar imageRatslinger gravatar imageJim K gravatar imageXLgaming_inc gravatar imagem.a.riosv gravatar imageEasyTrieve gravatar imageXoristzatziki gravatar imageLupp gravatar imagekarolus gravatar imageerAck gravatar imageSM_Riga gravatar imageKing_ZZ gravatar imageendolith gravatar imagegordon071 gravatar imageInopem gravatar imagepierre-yves samyn gravatar image