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?