Hi there,

I have two worksheets of data that are connected by a common field. I want
to merge these two worksheets (similar to how one might link up two DB
tables).

Is there a way I can do this in Excel.

Therefore the end result would be a single worksheet, and whenever the value
in the column that I choose from each worksheet matches, a single row in a
new worksheet is created.
(and where there is no match a new row is added, but does not have all the
columns populated).

Hope this makes sense.

Kind regards

Dave

FIND DUPLICATE RECORDS (COUNT), COMPARE DUPS BETWEEN DOCS, MERGE DOCS;
(sample of formula's: suite to fit your needs)
WORKING: (count duplicates, get "dif" from new to old sheet & merge data
with VLOOKUP..)
=IF(OR(V9={"",".",".sym."},COUNTIF($V$90:$V$3162,V 9)=1),"",COUNTIF($V$90:$V$3162,V9)) gets count same sheet
=IF(OR(V1={"",".",".sym."}),"",IF(ISNA(VLOOKUP(V1,[file.xls]sheet!$A$1:$A$3355,1,0)),"dif",""))
gets dif from diff sheet (must sort whole sheet, to 1 sheet..)
=VLOOKUP(V455,[file.xls]sheet!$A$1:$B$3355,2,FALSE) MERGE: WORKS FINE,
AGAIN: MUST SORT SHEET FOR GOOD RECORDS ONLY, WITH ABOVE top 2 EQ's
(Note: May want to use Copy, Paste-Special, Valutes of data you want to
copy into new sheet)
alternate formulas
=IF(ISNA(VLOOKUP(V1,[file.xls]sheet!$A$1:$B$3355,2,FALSE)),"",VLOOKUP(V1,[nasymbols.xls]a!$A$1:$B$3355,2,FALSE))
will get rid of n/a's, but do not want to copy blanks over other data, etc.
or:
=IF(V124={"",".",".sym."},"",VLOOKUP(V124,[file.xls]sheet!$A$1:$B$3355,2,FALSE)
which is an array formula, it should be committed with Ctrl-Shift-Enter,
not just Enter.

"David Smithz" wrote:

Hi there,

I have two worksheets of data that are connected by a common field. I want
to merge these two worksheets (similar to how one might link up two DB
tables).

Is there a way I can do this in Excel.

Therefore the end result would be a single worksheet, and whenever the value
in the column that I choose from each worksheet matches, a single row in a
new worksheet is created.
(and where there is no match a new row is added, but does not have all the
columns populated).

Hope this makes sense.

Kind regards

Dave