Forum Discussion
PLEASE HELP! How to combine two tables using multiple common values. Not opposed to VBA or formulas.
I have two tables. One table has a value in column A that is duplicated, and in column B there is a somewhat unique identifier. In the second table there is one value for column A that matches the fi...
As variant since 365 is mentioned
with
=XLOOKUP([@Test]&[@Try],
Table2nd[Test]&Table2nd[Try],
Table2nd[Value],
"-")