Tricky XLOOKUP or Index Match across multiple columns in Excel

390 Views Asked by At

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

0

There are 0 best solutions below