(V)Lookup only to rows with specific values

[Daniel_Fdrvc]

Hi all,

i've stucked. I have two tables: Table1 and Table2.
In Table2 i have column with values (Table2[Status]) that i need to vlookup to Table1, but only to rows which contains in column Table1[Product] = "Out". If there is other value than "Out" should leave blank. Both tables have same column [ID] to use in vlookup function. No ideas how to do that... Thank you in advance for any suggestions.

[v-robertq-msft · Accepted solution]

Hi, @Daniel_Fdrvc 

According to the error message, you can change the measure like this and try if it can work:

Column =

IF(Table1[Product]="Out",

CALCULATE(MAX(Table2[Status]),FILTER(Table2,[ID]=Earlier(Table1[ID])))

,0)

If you can not get what you want, you can post some sample data(without sensitive data) and your expected result.

How to Get Your Question Answered Quickly 

Best Regards,

Community Support Team _Robert Qin

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Daniel_Fdrvc]

Column = IF(Table1[Product]="Out",LOOKUPVALUE(Table2[Status],Table2[ID],Table1[ID]),0) returns error "a table of multiple values was supplied where a single value was expected"

[amitchandak]

@Daniel_Fdrvc , seem like there are more than one value in another table.

Try this

IF(Table1[Product]="Out", maxx(filter(Table2,Table2[ID]= Table1[ID]),Table2[Status] ) ,0)

refer my video on the same : https://www.youtube.com/watch?v=czNHt7UXIe8