Find and select first #N/A cell in a filtered selection....

Hi I am a complete novice and would like to know how to search and find, and select the first #N/A within my data.

Columns("C:C").Select
    Selection.Find(What:="#N/A", After:=ActiveCell, LookIn:=xlFormulas, _
        LookAt:=xlWhole, SearchOrder:=xlByRows, SearchDirection:=xlNext, _
        MatchCase:=False, SearchFormat:=False).Activate

Above is my current filter.

After this I would like to find first N/A to apply my Vlookup.

Any pointers are greatly appreciated.

Thank you.