Get Value from another cell

Hi there
I want to grab a value from another cell based on a value.

So “0 Grundstück” should go in all the cells where the BKP Nr matches the Hyr1.

I tried filtering, but dooesnt give me the answer i need.

later in the table it should take the NR.1

Thanks for your help!

Hi @Vesely_Architektur,

It’s much easier for me and others to help you if you share your doc with us (or create a dummy doc and share this). We can take a look into the formulas and everyone can make a copy of the document so we don’t get in the way of each other.

Please follow this guide to share your doc with us:

Greetings from Germany
Jannis Mürkens

Hi @Vesely_Architektur

Please check the doc below and let me know if that is what you expect to achieve.

As @Jannis said please share a dummy doc (it takes less that 5 minutes) so more colleagues can help you as it makes it easier to understand your use case.

I assumed that the BKP_NR22 and Hyr1 columns are numbers and not text columns.

Thanks guys

Heres the published version:

I think i got it now. im trying with first(). In the original big list, this didnt work, because it was refereing to a concenatet row.
First() just doesnt seem optimal. i want the exact cell. do you have an idea?

maybe i wasnt so clear:
i have main category and subcategory/elements. and i want to see to which main category the subelement belongs:

with this table it works with first(), but on the bigger one it doesnt.

I figured it out!
The problem was the “natural” row sorting of coda. I sorted the table, but the it still took first() as the first in the naturall sorting (when i copy pasted it). So i reordererd in Excel and copy pasted it.
Now it works fine :slight_smile:

1 Like