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

55 questions

Tagged
  • ×
  • ×
30
views
1
answer
no
votes
2021-01-06 22:40:27 +0100 m.a.riosv flag of Spain

Range lookup in Calc?

44
views
1
answer
no
votes
2020-12-16 20:54:31 +0100 erAck flag of Germany

How to lookup the first non '0' number in a list?

46
views
no
answers
no
votes
2020-11-03 15:53:24 +0100 the gridlock

Lookup question? [closed]

48
views
2
answers
no
votes
2020-10-24 00:23:39 +0100 TomH2020

Lookup smallest in column [closed]

2k
views
2
answers
no
votes
2020-10-15 16:24:42 +0100 Alex Kemp flag of United Kingdom of Great Britain and Northern Ireland

how to 'vlookup' on multiple criteria [closed]

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

In Calc, lookup values in date ranges by start date

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

Help reaching the last match

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

debugging LOOKUP()

166
views
1
answer
no
votes
2020-04-28 05:04:02 +0100 flywire

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

1k
views
3
answers
no
votes
2020-03-07 11:39:45 +0100 gregors15

Lookup data from different sheet

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

Calculate averages from several data ranges

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

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

90
views
no
answers
no
votes
2019-10-18 11:53:50 +0100 GicleeChris

look up value from contents of list

421
views
1
answer
no
votes
2019-09-04 12:26:51 +0100 Opaque

lookup function between 2 files

54
views
1
answer
1
vote
2019-08-05 01:58:47 +0100 Lupp

Pull data from long-form schedule to single day sheet

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

OpenOffice v LibreOffice Calc Function problem

235
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

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

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

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

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

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

LOOKUP with linear interpolation for missing values

168
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

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

Lookup formula assistance

Resources

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

Contributors

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