Forum Discussion
lookup values based on two columns
Hi Gurus,
I have two tables, I want a new column in tabel one looking up ID and Rev on Tabel 2 get the value of the Completed column in to the Tabel 1
4 Replies
Fowmy, Thanks champion. it works.
so if its even for more columns you can still give the combination ? means say we have three columns matching from both tabels,
does column names have to be in an order.
Anonymous
Yes, sure:
this is the syntax:
LOOKUPVALUE(
<result_columnName>,
<search_columnName>,
<search_value>
[, <search2_columnName>, <search2_value>]…
[, <alternateResult>]
)________________________
Did I answer your question? Mark this post as a solution, this will help others!.
I accept KUDOS 🙂
Anonymous , Try new column like in Table 1
new COlumn = minx(filter(table2,Table2[ID]=Table1[ID]),Table2[Completed])
In case table2 -> Table1 is 1 to M join
new COlumn =related(Table2[Completed])
