Matching two columns (differing zeros)

[awsz]

Hey everyone!

I have two separate datasets that need to be matched using the CUSIP code (company identifier). The problem is that in one dataset the code is 8-digit with zeros in the end and in the other dataset it is 7-digit code (thus without zeros). Thus I have a choice to either add zero in the end for 7-digit code, or remove the zero from the 8-digit code. Please see the attachment.

Many thanks in advance.

Hans

[Special-K]

=MATCH(D2&"0",A$2:A$31,0)
and copy down
but most of your sample doesnt match even with a 0 added, not really the best sample data I've seen.

[awsz]

Thank you, Special-K!

The sample I provided is just 30 observations out of 800, and thus I expect eventual matches (based on dataset characteristics).
Adding/removing zeros from the end of the value is just the first step, as to match two datasets, I will be using Vlookup.
Thus for this moment, I need to either add a zero to the end of the second column, or remove a zero from the end of the first column.

I hope I explained myself more clear now, if not, please let me know!

Thanks,

Hans