Hi Ryan,

You can simply use =.
For example...

= 3rd Party value = your value
or

=A2=B2

will return TRUE or FALSE.

If you only wanted to match against the first two characters of each
use the LEFT function.

eg. = LEFT(A2)=LEFT(B2)

Hope this works for you.

Regards,
Les Bantleman



RyanYoungsma wrote:
I am working in a file that I need to do a Comparison of the information in
the cell. We get data from an outside organization and I need to compare
what we have for data and what we are getting from the 3rd party.

Currently I create a worksheet with the data from the third party, then pull
in our data through an application we have created. This ensures that it is
aligned with the corresponding data point from the 3rd party.

3rd Party Data Our Data
xxx xxx

What i want to create is VB program or formula that will compare the 1st or
even the 1st two characters in the cells.

Does anyone have any thoughts on this?

Thank you,
Ryan

Oops....the LEFT function should be LEFT(A2,2) or the number of
characters to return.

Hope all is clear,

Les



wrote:
Hi Ryan,

You can simply use =.
For example...

= 3rd Party value = your value
or

=A2=B2

will return TRUE or FALSE.

If you only wanted to match against the first two characters of each
use the LEFT function.

eg. = LEFT(A2)=LEFT(B2)

Hope this works for you.

Regards,
Les Bantleman



RyanYoungsma wrote:
I am working in a file that I need to do a Comparison of the information in
the cell. We get data from an outside organization and I need to compare
what we have for data and what we are getting from the 3rd party.

Currently I create a worksheet with the data from the third party, then pull
in our data through an application we have created. This ensures that it is
aligned with the corresponding data point from the 3rd party.

3rd Party Data Our Data
xxx xxx

What i want to create is VB program or formula that will compare the 1st or
even the 1st two characters in the cells.

Does anyone have any thoughts on this?

Thank you,
Ryan