Problem with VLOOKUP() function and data formatting

I want to compare column 1 to column 2, the issue is that some fields have both numbers mixed with text so my function is not giving me accurate comparisons:

current function with the inaccurate results:
=IF(ISNA(MATCH(A6167, $C$2:$C$12713, 0)), A6167 & " is a financial asset that does NOT match a D7i asset", A6167 & " is a financial asset that matches a D7i asset")

Proposed function with the possible fix
=IF(ISNA(VLOOKUP(A2,Sheet1!$C$2:$C$12713,1,FALSE))=TRUE,VLOOKUP(VALUE(A2),Sheet1!$C$2:$C$12713,1,FALSE),VLOOKUP(A2,Sheet1!$C$2:$C$12713,1,FALSE))

I must be doing something wrong with the Proposed function with the possible fix because it is not giving me accurate comparisons either. Does the propoased fix look right to you?

just to clarify what JB says

Please Login or Register  to view this content.

should probably be

Please Login or Register  to view this content.

but post workbook for a better reply