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.
petrawigginHelper I
Hello!
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.