combined if and vlookup

Hi all,

Thanks in advance for your help. This is probably pretty simple, but I have the following question.

Name jan feb mar April bonus
bob 1 1 0 0 50
don 1 1 1 1
george 1 0 0 0 25
max 1 1 1 1



Above is my data set. I am using the following formula to get what I am looking for: =IF(B2>0,0,VLOOKUP($A8,$A$1:$F$5,6,0))
which returns below and is generally what I am looking for

bob 0 0 50 50
don 0 0 0 0
george 0 25 25 25
max 0 0 0 0


However I want to replace b2>0 to just match up with the names on the list that have a bonus figure inputted. ex. I don't care about Don and Max

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.