Creating a deeply nested IF MATCH user defined function

I am attempting to accomplish a task in Excel that I believe would be best as a UDF as I am having trouble getting it to work as a formula and finding the errors is proving too complex.

Here is the formula, though it fails to produce "Other" in its current state.

=IF($A10="Group",IF(ISNA(OR(MATCH(MatchValue,ListTables!H:H,FALSE),MATCH(MatchValue,ListTables!B:B,FALSE),$J10,IF(ISNA(MATCH(MatchValue,ListTables!H:H,FALSE)),"Approved","Other")))),$J10)

I would like a UDF that can be written in Excel as =FunctionName(Group, MatchValue)

I understand recreating this as VBA code would be too much to ask in its current state, so some starting group for me to complete this myself would be great. I am unsure of the code necessary to set up the IF and MATCH equivalents in VBA.

I think the error comes from

ISNA(OR(...,...))

Try using
OR(ISNA(...),ISNA(...)) instead.