Lookupvalue with multiple results

[LucasRB90]

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 [ID],DATA [Parent ID])

I got #Error as result. The table has arround 200k rows.

Basically what I looking is to get like a VLookUp for "Target from Parent".

Thanks!

[Greg_Deckler]

What is the error that you are getting? Are you getting back multiple results from your LOOKUPVALUE? You can try:

MAXX(FILTER('DATA',[ID] = [Parent ID]),[Target])

[LucasRB90]

Hi,

Thanks for that but it didn't solve my problem.

I need like a VLookUp for the column "Target Feature ID 2" based on the value of column "Work Item ID" and return the value of "Targeted Release Form"

So based on that I did 

LOOKUPVALUE(COMBINED[Targeted Release Form],COMBINED[Work Item Id],COMBINED[Feature ID 2])

But got the error of "A table with multiple values was supplied where a single value was expected"

If you can solve this I will be in debt lol

[Greg_Deckler]

OK, 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:

1. Post sample data as text using the table function in the editing bar. Just include the columns that are actually pertinent
2. Post what you expect as output

An explanation of the logic to get from a to b never hurts either. @LucasRB90 

[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