Forum Discussion
Lookup value from one row and return value from a different row
Hi Anonymous ,
According to your description, here's my solution.
Table1:
Table2:
Create a calculated column in Table1:
Job Reference Check = LOOKUPVALUE ( 'Table2'[Title], 'Table2'[Cascade Check], 'Table1'[ParentID Check] )Get the correct result.
I attach my sample below for your reference.
Best Regards,
Community Support Team _ kalyjIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Community SupportHi Anonymous ,
According to your description, here's my solution.
Table1:
Table2:
Create a calculated column in Table1:
Job Reference Check =
LOOKUPVALUE (
'Table2'[Title],
'Table2'[Cascade Check], 'Table1'[ParentID Check]
)
Get the correct result.
I attach my sample below for your reference.
Best Regards,
Community Support Team _ kalyj
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Helper IHello!
How would this be done if all the data were in the same table? Example:
| Key | Year | Vendor | OutwardReference | InwardReference |
| 1234 | 2020 | A | 7890 | |
| 2345 | 2021 | A | 6789 | |
| 6789 | 2024 | A | 2345 | |
| 7890 | 2024 | B | 1234 | |
| 9982 | 2024 | B | ||
| 1001 | 2020 | A | 2002 | |
| 2002 | 2020 | A | 1001 |
I want to look up each OutwardReference in the Key column and then return the year and vendor of the row where it is found.
EDIT
Actually, I realize I also need an IF statement in there: I only want the later year and later status IFF the later year is different from the year. (This is data from JIRA and I only want to know about the status of a cloned ticket if it was cloned into a project with a different year, not if it was cloned into a project in the same year it was created itself.)
So, the results would look like this:
| Key | Year | Status | OutwardReference | InwardReference | LaterYear | LaterStatus |
| 1234 | 2020 | A | 7890 | 2024 | B | |
| 2345 | 2021 | A | 6789 | 2024 | A | |
| 6789 | 2024 | A | 2345 | |||
| 7890 | 2024 | B | 1234 | |||
| 9982 | 2024 | B | ||||
| 1001 | 2020 | A | 2002 | |||
| 2002 | 2020 | A | 1001 |
What is the best way? Thank you.