I fixed all of the semicolons, but it is still giving me an N/A value. Any
other help?

"Joachim" wrote:

Hallo Kclyn,

Oops, my apologies. Please replace all semicolons between the formula
arguments with commas.
--
Regards

Joachim


"Kclyn" wrote:

Thank you for the help, but when I insert your formula in B2 it is showing
invalid. Can you please advise?

"Joachim" wrote:

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.
--
Regards

Joachim


"Kclyn" wrote:

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?