1 year ago
#295181
Lynn
Tricky XLOOKUP or Index Match across multiple columns in Excel
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
excel
excel-formula
vlookup
index-match
0 Answers
Your Answer