Yes/No using criteria in two cells on second worksheet

[theAphex]

On the primary sheet I have a list of 10 names in Column A, followed by a list of 10 user ID's in Column B.

Ex:/

  NAME       USER ID      YES/NO
  AAA         A12345
  BBB         B56789
  CCC         C56898
etc...

I need a formula in column C to look at data on a second sheet (which contains over 100 user ID's), find the row that matches the user ID and check in Columns D or E (on second sheet) to see if either is greater than 0. If the either is greater than 0, i want it to return a YES, if not, NO.

I figure i would need some combination of an If/Then with a Vlookup, but im getting stuck.

Any help would be greatly appreciated!!


EDIT: I'm actually starting to wonder if a 'Countif' function may be better suited for this problem.

 

[Robert Mika]

Assuming that there will be always number in column D & E:
=IF(OR(INDEX(Sheet2!$A$2:$E$4,MATCH(B2,Sheet2!$A$2:$A$4,0),4)>0,INDEX(Sheet2!$A$2:$E$4,MATCH(B2,Sheet2!$A$2:$A$4,0),5)>0),"YES","NO")