Having Troubles with Index Matching from a table

[JashVash]

Hello,

I am having trouble with my code to reference from a table called "jobtype" I have the codes below and the full code below. The Macro runs with "test" text but as soon as I used the formula below of index match.
It just goes on an endless loop. Do I need to define where my table is first before it reads the range of the table since it is in a different sheet?

Application.WorksheetFunction.Index(Range("jobtype[Trade]"), Application.WorksheetFunction.Match(Range(cell3), Range("jobtype[IFS]"), 0))

Supporting code and spread sheet images are below.

Thank you!

Sub IFSVlook()

Dim cell3 As Range
Dim Ifs As Worksheet
Dim LastRow As Long





Set Ifs = ThisWorkbook.Sheets("IFS Upload")

LastRow = Cells(Rows.Count, 1).End(xlUp).Row
   
For Each cell3 In Worksheets("IFS Upload").Range("N2:N" & LastRow)
On Error Resume Next
If Len(cell3.Value) > 0 Then
cell3.Offset(0, 1) = Application.WorksheetFunction.Index(Range("jobtype[Trade]"), Application.WorksheetFunction.Match(Range(cell3), Range("jobtype[IFS]"), 0))
  
   
End If

Next


 

End Sub

 

[Fluff]

Duplicate to: VBA Index Match on a table help

In future, please do not post the same question multiple times. Per Forum Rules (#12), posts of a duplicate nature will be locked or deleted.

In relation to your question here, I have closed this thread so please continue in the linked thread.