vlookup on 2 columns

  • Thread starter Thread starter dk
  • Start date Start date
D

dk

We want to make a vlookup on 2 columns ex;if a :b match with other woorksheet
the contents of c:d shall be updated from second c:d
explanation
a: john b:Doe c;(address) d:(city) the c d shall get filled from other
worksheet only when a:is john & b:is Doe
 
Just create a concat helper col & then use that as the new lookup col for
your vlookup, eg insert a new, "leftmost" col A, then place in A2, copy down:
=IF(COUNTA(A2:B2)<2,"",B2&"#"&C2)
(Do likewise for the other sheet)
 
Typo, the suggested concat formula should read as:
=IF(COUNTA(B2:C2)<2,"",B2&"#"&C2)

---
 
We have to do this in both workbook?

Max said:
Just create a concat helper col & then use that as the new lookup col for
your vlookup, eg insert a new, "leftmost" col A, then place in A2, copy down:
=IF(COUNTA(A2:B2)<2,"",B2&"#"&C2)
(Do likewise for the other sheet)
Click to expand...
 
We have to do this in both workbook?

To keep it simple to understand what's happening, Yes. By that I mean you
can then simply vlookup the new concat col A in Sheet1 vs the source in
Sheet2 (with the new concat col A).

---
 
Back
Top