fairly basic excel question (i hope)

M

mibro

I don't have any VBA skills but need to combine data from two excel
lists. one list (A) has 7000 records with many fields against each
unique company, the other list (B) has about half this amount of the
same unique companies (all on original list) but 3 additional fields
that I need to import into the main dataset. So basically is it
possible to set up a formulae that says "If company name in data set
B1 = any company name in data set A then import fields B2, B3 B4 into
dataset A against matching company name - without disturbing the other
fields in A.

Any help greatly appreciated as I asked someone to do this manually
and lost much of the data and much time and now well behind.

mibro
 
T

Tom Ogilvy

Assume the next open column is M, so in M2 on the sheet with 7000 companies,
put in a formula
=vlookup(A2,Sheet2!A2:D3500,2,False)
in N2
=vlookup(A2,Sheet2!A2:D3500,3,False)

and in O2
=vlookup(A2,Sheet2!A2:D3500,4,False)

These would get the values in columns B, C, D of Sheet2

You can then select these three cells and drag fill down the column

if a match is not made, you get #N/A

select M:O, then do
Edit=>goto => Special, select formulas and Errors and do Edit=>ClearContents

Now select M:O, do Edit copy, then Edit=>Pastespecial and select Values.

this will replace your formulas with the results.
 
Top