I have a problem with the data I have on my worksheet and
was wondering if maybe you guys can help. I have a column
of data actually part numbers in column D on worksheet
Open P.O. that I'm matching with part numbers in column G
on another worksheet, the formula below is what I have in
place. Now the problem I'm having is that some of the part
numbers in column D on worksheet Open P.O. have a # 1 at
the end of it, this is there because the data was imported
from our system and was placed there. but the data in
column G on the other worksheet was manully typed in by
users without the # 1 at the end of the part #. These 2
part #'s are the same but when i use the formula below
it's looking for an exact match and will return a value of
false. How can I modify the formula or create a macro that
can make these distinct differences and return a value of
yes. Hope this makes sense and thanks for any help you can
offer.

=IF(ISERROR(MATCH(G2,'Open P.O.'!
$D$2:$D$30000,0)),"NO","YES")