Adding columns from one table to another with no relations in between them

[Anonymous]

Hello!

I wanted to know what are the ways to connect/ relate  tables with nothing in common between them?

As there is no relationship between the table things have been a bit difficult.

I tried merging, joining, used related function, used join function. 

Also used Lookup values function, but following  error was thrown.

Please suggest some other means or if we could resolve the current error.

[amitchandak · Accepted solution]

@Anonymous , There is more than one value 

example

maxx(filter(Table2, Table1[ID] = Table2[ID] && Table1[Col1] = Table2[Col2] ), Table2[Value])

refer 4 ways to copy data from one table to another
https://www.youtube.com/watch?v=Wu1mWxR23jU
https://www.youtube.com/watch?v=czNHt7UXIe8