VBABEGINER
Well-known Member
- Joined
- Jun 15, 2011
- Messages
- 1,284
- Office Version
- 365
- Platform
- Windows
Dear All,
Need your help in re-design the formula in more professional way.
Pls help..
Need your help in re-design the formula in more professional way.
Pls help..
=IF($D11<>"",IF($A11="Yes",TEXT(IFERROR(VLOOKUP(CONCATENATE($C11,$D11,$E11,$F11,$G11,$H11),Weekly_Pivot!$DV:$ED,8,0)/VLOOKUP(CONCATENATE($C11,$D11,$E11,$F11,$G11,$H11),Weekly_Pivot!$DV:$ED,9,0),"-"),"0.0%"),IFERROR(IF(AND($A11="No",OR($E11=$BJ$1,$E11=$BJ$2,$E11=$BJ$3,$E11=$BJ$4,$E11=$BJ$5,$E11=$BJ$6,$E11=$BJ$7,$E11=$BJ$8,$E11=$BJ$9,$E11=$BJ$10,$E11=$BJ$11,$E11=$BJ$12,$E11=$BJ$13,$E11=$BJ$14,$E11=$BJ$15,$E11=$BJ$16,$E11=$BJ$17,$E11=$BJ$18,$E11=$BJ$19,$E11=$BJ$20,$E11=$BJ$21,$E11=$BJ$22,$E11=$BJ$23,$E11=$BJ$24,$E11=$BJ$25,$E11=$BJ$26,$E11=$BJ$27,$E11=$BJ$28,$E11=$BJ$29,$E11=$BJ$30,$E11=$BJ$31,$E11=$BJ$32,$E11=$BJ$33,$E11=$BJ$34,$E11=$BJ$35,$E11=$BJ$36,$E11=$BJ$37,$E11=$BJ$38,$E11=$BJ$39,$E11=$BJ$40,$E11=$BJ$41,$E11=$BJ$42,$E11=$BJ$43,$E11=$BJ$44,$E11=$BJ$45,$E11=$BJ$46,$E11=$BJ$47,$E11=$BJ$48,$E11=$BJ$49,$E11=$BJ$50,$E11=$BJ$51,$E11=$BJ$52,$E11=$BJ$53,$E11=$BJ$54,$E11=$BJ$55,$E11=$BJ$56,$E11=$BJ$57,$E11=$BJ$58,$E11=$BJ$59,$E11=$BJ$60,$E11=$BJ$61,$E11=$BJ$62,$E11=$BJ$63,$E11=$BJ$64,$E11=$BJ$65,$E11=$BJ$66,$E11=$BJ$67,$E11=$BJ$68,$E11=$BJ$69,$E11=$BJ$70,$E11=$BJ$71,$E11=$BJ$72,$E11=$BJ$73,$E11=$BJ$74,$E11=$BJ$75,$E11=$BJ$76,$E11=$BJ$77,$E11=$BJ$78,$E11=$BJ$79,$E11=$BJ$80,$E11=$BJ$81,$E11=$BJ$82,$E11=$BJ$83,$E11=$BJ$84)),TEXT(IFERROR(VLOOKUP(CONCATENATE($C11,$D11,$E11,$F11,$G11,$H11),Weekly_Pivot!$DV:$ED,8,0)/VLOOKUP(CONCATENATE($C11,$D11,$E11,$F11,$G11,$H11),Weekly_Pivot!$DV:$ED,9,0),"-"),"0.00"),IFERROR(IF(AND($A11="No",OR($E11=$BK$1,$E11=$BK$2,$E11=$BK$3,$E11=$BK$4,$E11=$BK$5,$E11=$BK$6,$E11=$BK$7,$E11=$BK$8,$E11=$BK$9,$E11=$BK$10,$E11=$BK$11)),TEXT(IFERROR(VLOOKUP(CONCATENATE($C11,$D11,$E11,$F11,$G11,$H11),Weekly_Pivot!$DV:$ED,8,0)/VLOOKUP(CONCATENATE($C11,$D11,$E11,$F11,$G11,$H11),Weekly_Pivot!$DV:$ED,9,0),"-"),"$#,##0.00"),VLOOKUP(CONCATENATE($C11,$D11,$E11,$F11,$G11,$H11),Weekly_Pivot!$DV:$ED,8,0)),"-")),"-")),"")