VLookup Loop until data found?

I have been reviewing notes back to 2009 but have not found an answer yet. I have a VLookup formula I need help with. In the enclosed file I collect infraction information (Data tab column D and E) on users. Once enough infractions have occured a level is delivered (Data tab column G).

On our summary tab I need to be able to pull data into the H column (Comments) from the G column from the data tab for each user. The problem with a basic VLookup is it will return the first entry which in most cases is blank (user has not incurred Level yet). I need a VLookup (or other function) to loop until it finds an entry and returns it to the summary tab.

Any help would be greatly appreciated!

Tried
VLookup and Lookup functions

Thzat will return you #N/A error if no match..if you want to avoid it yxou can use something like:

=LOOKUP(REPT("Z",255),CHOOSE({1,2},"",LOOKUP(2,1/((Data!A:A=A5)*(Data!G:G<>"")),Data!G:G)))