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