S
Simon
Hello,
I am trying to compare 2 sets of information which should
be the same, but may not be (the reason for the project).
The information is from 2 different sources and as such
there is no common identifier other than the company name.
For each company however there are several entries, and
the only other field which defines these entires from each
other is revenue.
I have been using the following formula to search for the
company, then to search for a matching 'revenue' value.
=INDEX($G$2:$I$288,(MATCH
(A2&B2,$G$2:$G$288&$H$2:$H$288,0)),3)
The '0' at the end of the match function indicates an
exact match is require. I have tried both 1 and -1, and
only when it is '1' does a value get returned, however the
answer is wrong.
Is it possible for the above function to:
1 - Search for the company, then
2 - Search for the nearest revenue value,
3 - Hence returning the most accurate result?
Any help would be greatly appreciated.
Thanks
Simon
I am trying to compare 2 sets of information which should
be the same, but may not be (the reason for the project).
The information is from 2 different sources and as such
there is no common identifier other than the company name.
For each company however there are several entries, and
the only other field which defines these entires from each
other is revenue.
I have been using the following formula to search for the
company, then to search for a matching 'revenue' value.
=INDEX($G$2:$I$288,(MATCH
(A2&B2,$G$2:$G$288&$H$2:$H$288,0)),3)
The '0' at the end of the match function indicates an
exact match is require. I have tried both 1 and -1, and
only when it is '1' does a value get returned, however the
answer is wrong.
Is it possible for the above function to:
1 - Search for the company, then
2 - Search for the nearest revenue value,
3 - Hence returning the most accurate result?
Any help would be greatly appreciated.
Thanks
Simon