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