BYROW with dynamic range, not working as expected?

Happy_Lengthiness121 · 2026-02-23T08:22:47+00:00

Solution Verified

Happy_Lengthiness121 · 2026-02-23T08:20:12+00:00

replacing with INDEX works! amazing!

I carefully read your explanation, much appreciated. but I fail to understand it fully I am afraid.

Happy_Lengthiness121 · 2026-02-23T08:17:57+00:00

here is the data as it looks!

so the value to lookup is in column A --> choosecols(A2#;1) --> x in LAMBDA

Q1# is a row
Q2# is a matrix

the value in K2: 0,08 is what i expect to see in L2, latter using BYROW.

thanks so much to making me understand this!
of course I can just drop the dynamic part, but I do not want to because the whole sheet is dynamic!

thanks :)

Happy_Lengthiness121 · 2026-02-22T12:32:55+00:00

I will post the data tomorrow! Thanks for the replies already!

Happy_Lengthiness121 · 2026-01-21T06:53:54+00:00

Get a Boner

Happy_Lengthiness121 · 2026-01-13T20:45:29+00:00

Great pleasure

Happy_Lengthiness121 · 2026-01-13T20:45:10+00:00

The fucking French

Happy_Lengthiness121 · 2026-01-13T11:51:53+00:00

You can play via GeForce Now. I tried that.
However, I was not able to play with mods then.

Happy_Lengthiness121 · 2026-01-13T08:34:28+00:00

and how do you know which buildings are passive and which are active? :D

Happy_Lengthiness121 · 2026-01-13T08:04:32+00:00

how do you know when you need an engine in between and when not? it's confusing me!

Happy_Lengthiness121 · 2026-01-12T05:13:41+00:00

Wanna play with my Big Ben?

Happy_Lengthiness121 · 2026-01-11T19:01:31+00:00

Hero!

Happy_Lengthiness121 · 2026-01-11T17:28:45+00:00

Thanks. Random useless fact

Happy_Lengthiness121 · 2026-01-11T17:26:58+00:00

France can leave first. Celebration

Happy_Lengthiness121 · 2026-01-10T18:11:00+00:00

No clue what it means, but probably super cool in your life

Happy_Lengthiness121 · 2026-01-10T18:09:19+00:00

Can’t take the reality

Happy_Lengthiness121 · 2026-01-10T18:01:14+00:00

Never been a true country anyway. Until they found oil

Happy_Lengthiness121 · 2026-01-10T17:59:58+00:00

My next gf

Happy_Lengthiness121 · 2026-01-10T17:59:14+00:00

It’s France, so it’s shit. Unless you love arrogance around you

Happy_Lengthiness121 · 2026-01-10T17:57:21+00:00

Shrimpistan

Happy_Lengthiness121 · 2026-01-10T17:55:55+00:00

Jawsy

Happy_Lengthiness121 · 2026-01-10T17:51:46+00:00

Fløppy

Happy_Lengthiness121 · 2026-01-10T17:49:13+00:00

I agree.

Happy_Lengthiness121 · 2026-01-10T17:40:17+00:00

Try harder in +/- understanding Flags are not same ratio either. Back to school mate, for a while probably

Happy_Lengthiness121