Hi everyone

Hope this isn't a silly question (as think I may have made it harder in my
head than it needs to be! given all the formulas I'm putting in are bringing
back errors!!)

I have one worksheet which gathers info from other sheets and has the
following info

A B C D
Name % % %

In another worksheet I have a list of names (column M say M3) next to the
names I want to put in a formula that will give me the following results:

If M3 is in worksheet 1 and the corresponding cells to that name in b, c and
d are all 0% write Yes otherwise write No but if M3 doesnt match anything on
the list write - .

Thanks as always

Kiwi