No, if you are using worksheet formulas, just use INDEX and MATCH; no need for Application.Worksheetfunction

You don't have to name the table, you just need to pass it as a range to the function.