What is wrong with my code here? (Missing IF or End Sub statement?)

If the original question is no longer a problem you should mark the thread as [SOLVED] and start a new thread with an appropriate title.

Is the N/A a product of a vlookup?