Forum Discussion
Solved
Lookupvalue between tables with partial text
Hello all, I need a help with the situation below. I have two table: Table1: Part number Description Status 1252 Bearing Critical 993 Filter Non critical Table2: ...
fhfon , Try a new column in Table2 like
Maxx(filter(Table1, search(Table1[Description], Table2[Description],,0) >0 ), Table1[Status])
Thank you!
This worked as I wanted.
amitchandak
Super User
Super Userfhfon , Try a new column in Table2 like
Maxx(filter(Table1, search(Table1[Description], Table2[Description],,0) >0 ), Table1[Status])
Thank you!
This worked as I wanted.