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
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
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 
This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.
