How to lookup text in list to pull list property? (Non-unique list)

I have 2 lists, lets call them ‘list1’ and ‘list2’. ‘list2’ has two properties with all values populated: ‘name’ and ‘product’.
 

‘name’ is a text property with duplicative values and ‘product’ is a dimension ‘product L0’.

‘list1’ has the same properties, with only ‘name’ populated. What formula can I in the ‘product’ property from ‘list1’ to call ‘product’ from ‘list2’ by looking up ‘list1.name’ against ‘list2.name’?