Forum Discussion
Lookupvalue with multiple results
Hi Everyone, I have the following table ID / Target / Parent ID / Target from Parent ID x / x / x / lookupvalue formula The formula I used is Target from Parent = LOOKUPVALUE(DATA [Target],DATA [I...
Greg_Deckler
Community Champion
Community ChampionOK, now I am super confused becaues it looks like your Feature ID 2 always matches your Work ID in the same row so I am not sure what you are trying to do.
Please do the following:
- Post sample data as text using the table function in the editing bar. Just include the columns that are actually pertinent
- Post what you expect as output
An explanation of the logic to get from a to b never hurts either. LucasRB90
Hi Greg,
It reaches a point where the data is different from one column to the other.
| work item id | targeted release form | feature id 2 | target feature id 2 |
| 109768 | 20.4 | 106850 | formula wanted |
| 109768 | 20.4 | 108431 | formula wanted |
| 110425 | 20.4 | 108431 | formula wanted |
So with this example, the formula that I want is like a VLookUp of excel that searchs for the value in "feature id 2" between column "work item ID" and returns the value from column "targeted release form"
This table has arround 100k rows.
The values in column "Feature ID 2" will be the parent ID of the ones in "Work Item ID" if that helps to understand the idea
Thanks again