software

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 quot;difquot; from new to old sheet amp; merge data
with VLOOKUP..)
=IF(OR(V9={quot;quot;,quot;.quot;,quot;.sym.quot;},COUNTIF($V$90:$V$3162,V 9)=1),quot;quot;,COUNTIF($V$90:$V$3162,V9)) gets count same sheet
=IF(OR(V1={quot;quot;,quot;.quot;,quot;.sym.quot;}),quot;quot;,IF(ISNA(VLOOKUP(V1,[file.xls]sheet!$A$1:$A$3355,1,0)),quot;difquot;,quot;quot;))
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)),quot;quot;,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={quot;quot;,quot;.quot;,quot;.sym.quot;},quot;quot;,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.

quot;David Smithzquot; wrote:

gt; Hi there,
gt;
gt; I have two worksheets of data that are connected by a common field. I want
gt; to merge these two worksheets (similar to how one might link up two DB
gt; tables).
gt;
gt; Is there a way I can do this in Excel.
gt;
gt; Therefore the end result would be a single worksheet, and whenever the value
gt; in the column that I choose from each worksheet matches, a single row in a
gt; new worksheet is created.
gt; (and where there is no match a new row is added, but does not have all the
gt; columns populated).
gt;
gt; Hope this makes sense.
gt;
gt; Kind regards
gt;
gt; Dave
gt;
gt;
gt;