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

36 questions

Tagged
  • ×
  • ×
19
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

14
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

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

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

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

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

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

LOOKUP with linear interpolation for missing values

40
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

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

Lookup formula assistance

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

Lookup for reference

781
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

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

making a lookup table

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

CALC: How to lookup a formula instead of a value

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

Joining the results of a LOOKUP or VLOOKUP

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

Insert multiple rows from a query

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

USING LOOKUPs but not working Libreoffice

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

calc - find value in subtable

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

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

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

Trying to use vlookup with indirect

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

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

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

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

Error trying to lookup date range

605
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

m.a.riosv gravatar imageXLgaming_inc gravatar imageJim K gravatar imageLupp gravatar imageXoristzatziki gravatar imageJohnSUN gravatar imagekarolus gravatar imageendolith gravatar imageSM_Riga gravatar imageerAck gravatar imageKing_ZZ gravatar imagepierre-yves samyn gravatar imagemanwenc gravatar imageInopem gravatar imageyahyaerturan gravatar imagecaliray gravatar image