Ask Your Question

medicengonzo's profile - activity

2018-01-11 20:07:20 +0100 received badge  Notable Question (source)
2018-01-11 20:07:20 +0100 received badge  Famous Question (source)
2017-12-06 10:47:08 +0100 received badge  Notable Question (source)
2017-07-27 14:04:06 +0100 received badge  Notable Question (source)
2017-06-13 11:52:13 +0100 received badge  Popular Question (source)
2017-03-15 15:31:35 +0100 received badge  Popular Question (source)
2017-03-15 02:24:27 +0100 commented answer Calc: vlookup gives Err.502 though I'm sure the syntax is correct.

That's it. Such a NOOB mistake. Thank you!

2017-03-14 19:25:12 +0100 asked a question Calc: vlookup gives Err.502 though I'm sure the syntax is correct.

I have a list of values on column A in column B I want to apply a VLOOKUP with the search value in A and the array in another sheet and give me index 3. I use the following formula: =VLOOKUP($A1,Sheet1.$A$2:$A$27,3,0)

Somehow this gives me Err.502

I don't understand what I am doing wrong.

Also, if I change the formula to look on index 1 it gives me the same value of cell A1 .

2017-03-10 02:23:54 +0100 received badge  Popular Question (source)
2017-03-09 20:02:26 +0100 commented answer Increment by 6 when I pull down cell?

I don't quite follow. This is exactly what I'm trying to do: In column A I have references to cells on another sheet. Sheet1.A1, Sheet1.A7, Sheet1.A13 etc. I want this series to fill automatically on the reference so I don't have to write them manually and I get a reference of every 6th cell in Sheet1.

2017-03-09 19:02:21 +0100 commented answer Increment by 6 when I pull down cell?

This works for numbers but when I try with cell references it makes no sense.

In cells B1 and B2 I enter the following: =A1 and =A7. Then, when I pull down the handle it gives me:

A1, A7, A3, A9
2017-03-09 18:53:15 +0100 commented answer Reference a formula instead of a value?

Exactly what I needed! Thanks

2017-03-09 18:47:14 +0100 asked a question Increment by 6 when I pull down cell?

When I pull a cell down the cells are usually filled with a series of numbers that increase by 1.

1, 2, 3, 4, 5 etc.

I want to pull a cell and get all the other cells filled by an increment of 6

1,7,13 etc.

How do I go about doing so?

In excel I just have to fill the first three cells with the series I want and it fills automatically. Is there any way I can do something like this in Librecalc?

Also, I would like for this to apply to formulas as well.

2017-03-09 18:27:32 +0100 commented answer Reference a formula instead of a value?

Nice! Is there any way i can get it without the = sign? I mean sum(A1:A5). I am trying to use it in another formula.

2017-03-09 17:15:33 +0100 asked a question Reference a formula instead of a value?

Is it possible to refrence a formula in a cell instead of the value result of said cell?

For example:

I have the formula =sum(A1:A5) in the cell A1. In cell B1 i would like to reference the formula in A1 so instead of getting the result of the sum I get the string =sum(A1:B5)

Is this possible in LibreCalc?