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

34 questions

Tagged
  • ×
  • ×
1k
views
2
answers
no
votes
2012-09-02 21:05:32 +0200 Nando

Change in Indirect function [closed]

738
views
2
answers
no
votes
2014-10-25 19:30:25 +0200 m.a.riosv flag of Spain

Convert Excel multi function formula to Calc [closed]

232
views
2
answers
no
votes
2017-07-24 10:56:59 +0200 Lupp

=INDIRECT(A4 & ".O$17") doesn't work

541
views
1
answer
1
vote
2014-07-12 11:11:01 +0200 bencomp flag of Netherlands

How can I use nested VLOOKUPs? [closed]

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

Trying to use vlookup with indirect

445
views
1
answer
no
votes
2016-11-06 19:41:48 +0200 karolus flag of Germany

calc - filename from cell

41
views
1
answer
no
votes
2016-11-07 19:15:30 +0200 mark_t flag of Canada

calc - vary column in indirect

220
views
1
answer
no
votes
2016-11-21 17:09:24 +0200 mark_t flag of Canada

calc - function to define cellrange

86
views
1
answer
no
votes
2017-01-12 12:07:45 +0200 Lupp

Display Cell as Blank and not #REF!

66
views
1
answer
no
votes
2018-01-22 22:09:57 +0200 Jim K flag of United States of America

vlookup() inside indirect()

74
views
1
answer
no
votes
2018-07-15 13:42:33 +0200 m.a.riosv flag of Spain

Optimizing a Calc spreadsheet with 1000s of INDIRECT entries

438
views
1
answer
no
votes
2019-01-10 21:35:42 +0200 SM_Riga flag of Latvia

How to escape double quote in INDIRECT()

26
views
1
answer
no
votes
2019-08-14 14:15:10 +0200 erAck flag of Germany

Problem with hlookup and indirect [closed]

29
views
1
answer
no
votes
2019-09-01 00:26:21 +0200 Mike Kaganski flag of Russia

INDIRECT and arithmetic

190
views
no
answers
no
votes
2014-03-05 09:58:22 +0200 jene flag of Switzerland

How to define a print range with INDIRECT()? [closed]

9
views
no
answers
no
votes
2015-10-30 05:18:40 +0200 argh.pirate

Is there any way to shorten this formula?

Resources

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

Contributors

razon_22 gravatar imagekarolus gravatar imagegtomorrow gravatar imageJim K gravatar image007Charlette gravatar imageArchetype gravatar imagem.a.riosv gravatar imageLupp gravatar imageJohnSUN gravatar imageOpaque gravatar imageROSt52 gravatar imageerAck gravatar imageSM_Riga gravatar imageargh.pirate gravatar imageMike Kaganski gravatar imagekebs gravatar image