vlookup on 2 columns

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

dk - 01 May 2008 03:05 GMT

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

Reply to this Message

Max - 01 May 2008 03:28 GMT

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)

Signature

Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

> 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

Reply to this Message

Max - 01 May 2008 03:37 GMT

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

Signature

Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

Reply to this Message

dk - 02 May 2008 03:17 GMT

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:
[quoted text clipped - 5 lines]
> > 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

Reply to this Message

Max - 02 May 2008 04:26 GMT

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

Signature

Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

Reply to this Message