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 [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!
4 Replies
- Greg_Deckler
Community Champion
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])
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:
- 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
