Entering data which refers to different data in another cell

You could either

a) embed a pre-emptive test to ensure SUM(N4) > 0 before conducting the VLOOKUP

b) add a 0 years line to your VLOOKUP table (with 0 output in G)