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

54 questions

Tagged
  • ×
24
views
1
answer
no
votes
2020-08-12 18:12:46 +0200 Ratslinger flag of United States of America

add combo box to Base table field

28
views
3
answers
no
votes
2020-07-23 10:32:02 +0200 Mike Kaganski flag of Russia

In Calc, lookup values in date ranges by start date

29
views
1
answer
no
votes
2020-07-01 17:56:27 +0200 erAck flag of Germany

Help reaching the last match

53
views
2
answers
no
votes
2020-06-05 16:56:08 +0200 keme flag of Norway

debugging LOOKUP()

74
views
1
answer
no
votes
2020-04-28 05:04:02 +0200 flywire

Lookup Part of Text: Randomly Placed Text in Cell [closed]

51
views
2
answers
no
votes
2020-04-10 16:09:51 +0200 Ardee flag of Australia

Run Time Error for Record not found in Macro SQL

479
views
3
answers
no
votes
2020-03-07 11:39:45 +0200 gregors15

Lookup data from different sheet

62
views
1
answer
no
votes
2020-02-18 03:39:09 +0200 Ratslinger flag of United States of America

Base Lookup

77
views
1
answer
no
votes
2020-01-26 11:12:27 +0200 m.a.riosv flag of Spain

Calculate averages from several data ranges

78
views
2
answers
no
votes
2019-11-29 01:56:16 +0200 ProLogic flag of Philippines

Search criteria has 9E+100. What does it mean

58
views
no
answers
no
votes
2019-10-18 11:53:50 +0200 GicleeChris

look up value from contents of list

205
views
1
answer
no
votes
2019-09-04 12:26:51 +0200 Opaque

lookup function between 2 files

48
views
1
answer
1
vote
2019-08-05 01:58:47 +0200 Lupp

Pull data from long-form schedule to single day sheet

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

OpenOffice v LibreOffice Calc Function problem

161
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

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

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

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

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

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

LOOKUP with linear interpolation for missing values

116
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

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

Lookup formula assistance

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

Lookup for reference

2k
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

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

making a lookup table

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

CALC: How to lookup a formula instead of a value

Resources

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

Contributors

JohnSUN gravatar imageD.C.Ballard gravatar imagekeme gravatar imagem.a.riosv gravatar imagerobleyd gravatar imageXoristzatziki gravatar imageOpaque gravatar imageJim K gravatar imageLupp gravatar imagepierre-yves samyn gravatar imageRatslinger gravatar imageSM_Riga gravatar imageAndyfc gravatar imageerAck gravatar imageendolith gravatar image-rob- gravatar image