I wish to populate 'owned' column tab1 with values from tab2 'assigned' column IF tab2 'name2' column matches w tab1 'name' column
Data
tab1
A B
owned name
aa11
bb22
cc11
tab2
A B
name2 assigned
aa11 bob
dddd sherri
cc11 renee
Desired
tab1
owned name
bob aa11
bb22
renee cc11
tab2
name2 assigned
aa11 bob
dddd sherri
cc11 renee
Doing
=VLOOKUP(@G:G,'Tab2'!A:D,3,FALSE)
However, the data is not populating. Any suggestion is appreciated