sugardaddy095
New Member
- Joined
- Dec 28, 2016
- Messages
- 7
I'm trying to have A102 (Date Entered by user) if it matched any of the cells below, then it doubles the point value from the list. The values are not properly doubling, however, when stepping through the equation it works. Help!! ive been working on this for forever.
=IF(A102=OR($A$21,$J$24,$P$27,$K$30,$O$27,$J$30,$P$44,$J$46,$O$50,$P$50,$J$53,$K$53,$S$50,$Y$47,$X$53,$G$61,$A$64,$B$64,$C$64,$G$64,$A$67,$B$67,$C$67,$X$61,$Y$61,$S$64,$T$64,$N$90,$O$90,$P$90,$X$90,$Y$90,$S$93,$T$93,$U$93,$V$93,$W$93,$X$93,$Y$93,$S$96),(VLOOKUP($C102,$AR$7:$AT$30,3,FALSE)*2),(IFERROR(VLOOKUP($C102,$AR$7:$AT$30,3,FALSE),"")))
=IF(A102=OR($A$21,$J$24,$P$27,$K$30,$O$27,$J$30,$P$44,$J$46,$O$50,$P$50,$J$53,$K$53,$S$50,$Y$47,$X$53,$G$61,$A$64,$B$64,$C$64,$G$64,$A$67,$B$67,$C$67,$X$61,$Y$61,$S$64,$T$64,$N$90,$O$90,$P$90,$X$90,$Y$90,$S$93,$T$93,$U$93,$V$93,$W$93,$X$93,$Y$93,$S$96),(VLOOKUP($C102,$AR$7:$AT$30,3,FALSE)*2),(IFERROR(VLOOKUP($C102,$AR$7:$AT$30,3,FALSE),"")))