Search for value in column and compare values to show if they match don't match

Stuck in excel hell for the last while with this heres my problem:

Trying to check if my value in column c is a match to a value located somehwere in column h where colums a and f would contain the reference parts top match them, should i be moving the values from colums f out ward to a different sheet maybe?

using the formula below is spitting out an error.....if anyone can help i'd really appreciate it

=IF(LOWER(TRIM(C2)) = LOWER(TRIM(XLOOKUP(A2, F:F, H:H))), "Match", "Mismatch")

if anyone has any ideas of would know how to do this if moving information from colums f onwards out then please let me know how to do it as I'm at my wits end with this.