vlookup on 2 columns

[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 boe c;(address) dcity) the c d shall get filled from other
worksheet only when a:is john & b:is Doe

 

[Max]

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)

 

[Max]

Typo, the suggested concat formula should read as:
=IF(COUNTA(B2:C2)<2,"",B2&"#"&C2)

---

 

[dk]

We have to do this in both workbook?

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)

 

[Max]

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).

---