```
Sub Searchable()
Sheets("test").Select
    Range("C2").Formula = "=IFERROR(INDEX('Employee and Job List'!    $A:$A,MATCH(ROWS(test!$B$2:$B2),test!B:B,0)),"")"
        Range("C2").Select
            Selection.AutoFill Destination:=Range("C2:C1200")

End Sub

```

I'm trying to get this code to work and I'm getting am application-defined or objective-defined error I have another one just like it that works and then another that does. The only thing different is that the two witht he error start with an if function.

All help would be greatly appreciated.