How do I combine 2 Excel lists, or databases, with similar fields, into one list?
S stevenrhonda Mar 5, 2006 #1 How do I combine 2 Excel lists, or databases, with similar fields, into one list?
M Max Mar 5, 2006 #2 stevenrhonda said: How do I combine 2 Excel lists, or databases, with similar fields, into one list? Click to expand... VLOOKUP would be one way .. Try Debra Dalgleish's nice coverage at her page: http://www.contextures.com/xlFunctions02.html (there's a sample book for d/l there) Another way would be to use INDEX / MATCH which Debra also covers at her: http://www.contextures.com/xlFunctions03.html (a sample book for d/l is available there as well)
stevenrhonda said: How do I combine 2 Excel lists, or databases, with similar fields, into one list? Click to expand... VLOOKUP would be one way .. Try Debra Dalgleish's nice coverage at her page: http://www.contextures.com/xlFunctions02.html (there's a sample book for d/l there) Another way would be to use INDEX / MATCH which Debra also covers at her: http://www.contextures.com/xlFunctions03.html (a sample book for d/l is available there as well)
