X
xair
Hi,
I am trying to reconcile two accounts using the vlookup function. I have
column with a dollar amount in each excel sheet. I run a vlookup to compare
the two columns and give me the dollar amount in one sheet next to the
corresponding dollar amount in the second sheet. So I can find entries that
are there in one account and not in the other.
This works fine untill two or more consecutive amounts are the same in
column 1. IN this case the same dollar amount repeats itself even if it is
only present in one of the two sheets.
So then I have to go back and manually look at each dollar amount that
repeats its self more than once and make sure it is there in both sheets.
Does any one have any idea how I can get around this problem?
I hope I expnained this one clearly enough, let me know if you have any
questions.
Thanks!
I am trying to reconcile two accounts using the vlookup function. I have
column with a dollar amount in each excel sheet. I run a vlookup to compare
the two columns and give me the dollar amount in one sheet next to the
corresponding dollar amount in the second sheet. So I can find entries that
are there in one account and not in the other.
This works fine untill two or more consecutive amounts are the same in
column 1. IN this case the same dollar amount repeats itself even if it is
only present in one of the two sheets.
So then I have to go back and manually look at each dollar amount that
repeats its self more than once and make sure it is there in both sheets.
Does any one have any idea how I can get around this problem?
I hope I expnained this one clearly enough, let me know if you have any
questions.
Thanks!