Find and copy data from 2 worksheets

  • Thread starter Thread starter Kclyn
  • Start date Start date
K

Kclyn

I have two worksheets; one with company names and balance amounts, the other
with company names and addresses. I want to merge these together. Not all
of the companies on the balance sheet are on the addresses sheet. How can I
get these to come together?
 
Hallo Kclyn

Assuming company names and amounts in sheet1, columns A and B, company names
and adresses in sheet2, columns A and B, titles in line 1 and data starting
in line 2, and merged result in sheet3, balance amounts in Column B and
adresses in Column C:

1. Copy company names from sheet1 to column A, sheet3

2. sheet3, B2, insert formula:
=IF(ISERROR(VLOOKUP($A2;SHEET1!$A$2:$B$100;2;0));"";VLOOKUP($A2;SHEET1!$A$2:$B$100;2;0))

3. sheet3, C2, insert formula:

=IF(ISERROR(VLOOKUP($A2;SHEET2!$A$2:$B$100;2;0));"";VLOOKUP($A2;SHEET2!$A$2:$B$100;2;0))

Adust ranges as required an copy formulas down to last company name.
 
Thank you for the help, but when I insert the formula into B2 it shows
invalid. Can you please advise?
 
Thank you for the help, but when I insert your formula in B2 it is showing
invalid. Can you please advise?
 
Hallo Kclyn,

Oops, my apologies. Please replace all semicolons between the formula
arguments with commas.
 
N/A means the formula doesn't find some data. For any further comment I would
need to see examples of the first lines of your sheets.
 
Back
Top