Looking up values from another table

Hi

I have two tables. both have a master column called Name and a relationship exists between the name columns. 

each table has a values column. 

in Table 1 I want to add a column that looks up the value in Table 2 if the names in the name columns are the same. 

i've tried lookupvalue with the following syntax

Util = LOOKUPVALUE('table2'[value],'table2'[Name],'Table1'[Name])

however it only retuns one value for a cell called Blank. yet I know for a fact the names in the columns are the same. 

can anyone help with this?

thanks