K
Kiwi
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
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