Replace data with lookup from a different table

1

Hello,

I am working on a task list with data imported from another app. Everything is working pretty well, except there is one thing I can’t figure out. My tasks come in with a “Plan Id,” a long string of random letters and numbers. I have a separate table that matches those Ids to the Plan Name. I want to create a lookup so that the correct plan name displays next to each task. I have tired many things, but none of them work.

Here is the dummy table I set up: https://coda.io/d/dLmFAaKHTV/Task-List-with-Id-Lookups_suspB

The current formula is: Lookup(Planner, thisRow.[Plan Id], Planner.Name)

I’d greatly appreciate any assistance.

Thanks,

Anna

1 Like
2

hi @Anna.F , welcome to the community

good question, below how I solved it. Instead of a lookup function I used a filter and this goes as follows:

  1. first I reference the complete table, thus all the rows.
  2. next I filter them on Id
  3. and ask if each of these rows contais the value on this row
  4. if so, it gives back the value living in the display column

image
image2061×1298 222 KB

cheers, Christiaan

3 Likes
3

Thank you, @Christiaan_Huizer . This did the trick. :slight_smile:

1 Like
4

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.