HI

If you can add one column in front, then you can use this formula. Your bonus column will be G.

=if(G2>0,max(A$1:a1)+1,"")

you will get

1 bob 1 1 0 0 50
don 1 1 1 1
2 george 1 0 0 0 25
max 1 1 1 1


Then your vlookup will be changed to,

=VLOOKUP(A8,$A$1:$g$,6,0) and A8, A9..... you should put 1,2,....

Hope this solves your issue.