| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
vlookup on 2 columns
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 |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
vlookup on 2 columns
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 Singapore http://savefile.com/projects/236895 xdemechanik --- "dk" wrote: 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 |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
vlookup on 2 columns
Typo, the suggested concat formula should read as:
=IF(COUNTA(B2:C2)<2,"",B2&"#"&C2) -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- |
|
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
vlookup on 2 columns
We have to do this in both workbook?
"Max" wrote: 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 Singapore http://savefile.com/projects/236895 xdemechanik --- "dk" wrote: 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 |
|
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
vlookup on 2 columns
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). -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| VLOOKUP for 2 columns or more | Excel Discussion (Misc queries) | |||
| VLookup in to columns | Excel Worksheet Functions | |||
| Vlookup from 2 columns | Excel Worksheet Functions | |||
| Vlookup using two columns | Excel Worksheet Functions | |||
| Vlookup with 2 columns | Excel Discussion (Misc queries) | |||
Linear Mode
