Assigning of values from other table without relation (DAX - Lookup VAlue)

[DanielPasalic]

Hi
I'm trying to assign the value from other tables in another table and there is no table relation between those two tables. 
In this new table (table 2), where I'm trying to get the value from the old table (table 1), I created a new column according to the following:
Article name = LOOKUPVALUE (Reference_Merge_Standard_Opis_Dec[Artikelbeskrivning] = table 1 that contain the values I need
;Reference_Merge_Standard_Opis_Dec[Dec-19 butikstäckning behov] = the column in table 1, containing the "key"
; Reference_Merge_STANDARD_ranking[Dec-19 butikstäckning behov] = the column in table 2, containing the same "key"
after that I applied same steps as above for 5 different parameters but always get an error:
A table of multiple values was supplied where a single value was expected.

Anyone who can help me?

[V-pazhen-msft · Accepted solution]

@DanielPasalic 

The bold lookup formula seems incorrect for me. Check:

LOOKUPVALUE( <result_columnName>, <search_columnName>, <search_value>[, <search_columnName>, <search_value>]…[, <alternateResult>])   

Please share a sample pibx if possbile.

Best,
Paul