API tools faq
paste
Advertisement
Xavion

Single cell

Xavion
Mar 22nd, 2021
65
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 4.69 KB | None | 0 0
raw download clone embed print report
  1. =IF(IF($C$2,IF(COLUMN(G56)<9,MAX(VLOOKUP($C56,INDIRECT($F$55),10,FALSE)*VLOOKUP($C56,INDIRECT($F$55),11,FALSE)*VLOOKUP($F$54,$C$3:$N$8,12,FALSE)*NE(G$54,$F$54), VLOOKUP($C56,INDIRECT($G$55),10,FALSE)*VLOOKUP($C56,INDIRECT($G$55),11,FALSE)*VLOOKUP($G$54,$C$3:$N$8,12,FALSE)*NE(G$54,$G$54), VLOOKUP($C56,INDIRECT($H$55),10,FALSE)*VLOOKUP($C56,INDIRECT($H$55),11,FALSE)*VLOOKUP($H$54,$C$3:$N$8,12,FALSE)*NE(G$54,$H$54)),MAX(VLOOKUP($C56,INDIRECT($I$55),10,FALSE)*VLOOKUP($C56,INDIRECT($I$55),11,FALSE)*VLOOKUP($I$54,$C$3:$N$8,12,FALSE)*NE(G$54,$I$54), VLOOKUP($C56,INDIRECT($J$55),10,FALSE)*VLOOKUP($C56,INDIRECT($J$55),11,FALSE)*VLOOKUP($J$54,$C$3:$N$8,12,FALSE)*NE(G$54,$J$54), VLOOKUP($C56,INDIRECT($K$55),10,FALSE)*VLOOKUP($C56,INDIRECT($K$55),11,FALSE)*VLOOKUP($K$54,$C$3:$N$8,12,FALSE)*NE(G$54,$K$54))),MAX(VLOOKUP($C56,INDIRECT($F$55),10,FALSE)*VLOOKUP($C56,INDIRECT($F$55),11,FALSE)*VLOOKUP($F$54,$C$3:$N$8,12,FALSE)*NE(G$54,$F$54), VLOOKUP($C56,INDIRECT($G$55),10,FALSE)*VLOOKUP($C56,INDIRECT($G$55),11,FALSE)*VLOOKUP($G$54,$C$3:$N$8,12,FALSE)*NE(G$54,$G$54), VLOOKUP($C56,INDIRECT($H$55),10,FALSE)*VLOOKUP($C56,INDIRECT($H$55),11,FALSE)*VLOOKUP($H$54,$C$3:$N$8,12,FALSE)*NE(G$54,$H$54), VLOOKUP($C56,INDIRECT($I$55),10,FALSE)*VLOOKUP($C56,INDIRECT($I$55),11,FALSE)*VLOOKUP($I$54,$C$3:$N$8,12,FALSE)*NE(G$54,$I$54), VLOOKUP($C56,INDIRECT($J$55),10,FALSE)*VLOOKUP($C56,INDIRECT($J$55),11,FALSE)*VLOOKUP($J$54,$C$3:$N$8,12,FALSE)*NE(G$54,$J$54), VLOOKUP($C56,INDIRECT($K$55),10,FALSE)*VLOOKUP($C56,INDIRECT($K$55),11,FALSE)*VLOOKUP($K$54,$C$3:$N$8,12,FALSE)*NE(G$54,$K$54)))=0,"---",INDIRECT(CONCAT("R54C",match(IF($C$2,IF(COLUMN(G56)<9,MAX(VLOOKUP($C56,INDIRECT($F$55),10,FALSE)*VLOOKUP($C56,INDIRECT($F$55),11,FALSE)*VLOOKUP($F$54,$C$3:$N$8,12,FALSE)*NE(G$54,$F$54), VLOOKUP($C56,INDIRECT($G$55),10,FALSE)*VLOOKUP($C56,INDIRECT($G$55),11,FALSE)*VLOOKUP($G$54,$C$3:$N$8,12,FALSE)*NE(G$54,$G$54), VLOOKUP($C56,INDIRECT($H$55),10,FALSE)*VLOOKUP($C56,INDIRECT($H$55),11,FALSE)*VLOOKUP($H$54,$C$3:$N$8,12,FALSE)*NE(G$54,$H$54)),MAX(VLOOKUP($C56,INDIRECT($I$55),10,FALSE)*VLOOKUP($C56,INDIRECT($I$55),11,FALSE)*VLOOKUP($I$54,$C$3:$N$8,12,FALSE)*NE(G$54,$I$54), VLOOKUP($C56,INDIRECT($J$55),10,FALSE)*VLOOKUP($C56,INDIRECT($J$55),11,FALSE)*VLOOKUP($J$54,$C$3:$N$8,12,FALSE)*NE(G$54,$J$54), VLOOKUP($C56,INDIRECT($K$55),10,FALSE)*VLOOKUP($C56,INDIRECT($K$55),11,FALSE)*VLOOKUP($K$54,$C$3:$N$8,12,FALSE)*NE(G$54,$K$54))),MAX(VLOOKUP($C56,INDIRECT($F$55),10,FALSE)*VLOOKUP($C56,INDIRECT($F$55),11,FALSE)*VLOOKUP($F$54,$C$3:$N$8,12,FALSE)*NE(G$54,$F$54), VLOOKUP($C56,INDIRECT($G$55),10,FALSE)*VLOOKUP($C56,INDIRECT($G$55),11,FALSE)*VLOOKUP($G$54,$C$3:$N$8,12,FALSE)*NE(G$54,$G$54), VLOOKUP($C56,INDIRECT($H$55),10,FALSE)*VLOOKUP($C56,INDIRECT($H$55),11,FALSE)*VLOOKUP($H$54,$C$3:$N$8,12,FALSE)*NE(G$54,$H$54), VLOOKUP($C56,INDIRECT($I$55),10,FALSE)*VLOOKUP($C56,INDIRECT($I$55),11,FALSE)*VLOOKUP($I$54,$C$3:$N$8,12,FALSE)*NE(G$54,$I$54), VLOOKUP($C56,INDIRECT($J$55),10,FALSE)*VLOOKUP($C56,INDIRECT($J$55),11,FALSE)*VLOOKUP($J$54,$C$3:$N$8,12,FALSE)*NE(G$54,$J$54), VLOOKUP($C56,INDIRECT($K$55),10,FALSE)*VLOOKUP($C56,INDIRECT($K$55),11,FALSE)*VLOOKUP($K$54,$C$3:$N$8,12,FALSE)*NE(G$54,$K$54))),IF($C$2,IF(COLUMN(G56)<9,{VLOOKUP($C56,INDIRECT($F$55),10,FALSE)*VLOOKUP($C56,INDIRECT($F$55),11,FALSE)*VLOOKUP($F$54,$C$3:$N$8,12,FALSE)*NE(G$54,$F$54), VLOOKUP($C56,INDIRECT($G$55),10,FALSE)*VLOOKUP($C56,INDIRECT($G$55),11,FALSE)*VLOOKUP($G$54,$C$3:$N$8,12,FALSE)*NE(G$54,$G$54), VLOOKUP($C56,INDIRECT($H$55),10,FALSE)*VLOOKUP($C56,INDIRECT($H$55),11,FALSE)*VLOOKUP($H$54,$C$3:$N$8,12,FALSE)*NE(G$54,$H$54)},{VLOOKUP($C56,INDIRECT($I$55),10,FALSE)*VLOOKUP($C56,INDIRECT($I$55),11,FALSE)*VLOOKUP($I$54,$C$3:$N$8,12,FALSE)*NE(G$54,$I$54), VLOOKUP($C56,INDIRECT($J$55),10,FALSE)*VLOOKUP($C56,INDIRECT($J$55),11,FALSE)*VLOOKUP($J$54,$C$3:$N$8,12,FALSE)*NE(G$54,$J$54), VLOOKUP($C56,INDIRECT($K$55),10,FALSE)*VLOOKUP($C56,INDIRECT($K$55),11,FALSE)*VLOOKUP($K$54,$C$3:$N$8,12,FALSE)*NE(G$54,$K$54)}),{VLOOKUP($C56,INDIRECT($F$55),10,FALSE)*VLOOKUP($C56,INDIRECT($F$55),11,FALSE)*VLOOKUP($F$54,$C$3:$N$8,12,FALSE)*NE(G$54,$F$54), VLOOKUP($C56,INDIRECT($G$55),10,FALSE)*VLOOKUP($C56,INDIRECT($G$55),11,FALSE)*VLOOKUP($G$54,$C$3:$N$8,12,FALSE)*NE(G$54,$G$54), VLOOKUP($C56,INDIRECT($H$55),10,FALSE)*VLOOKUP($C56,INDIRECT($H$55),11,FALSE)*VLOOKUP($H$54,$C$3:$N$8,12,FALSE)*NE(G$54,$H$54), VLOOKUP($C56,INDIRECT($I$55),10,FALSE)*VLOOKUP($C56,INDIRECT($I$55),11,FALSE)*VLOOKUP($I$54,$C$3:$N$8,12,FALSE)*NE(G$54,$I$54), VLOOKUP($C56,INDIRECT($J$55),10,FALSE)*VLOOKUP($C56,INDIRECT($J$55),11,FALSE)*VLOOKUP($J$54,$C$3:$N$8,12,FALSE)*NE(G$54,$J$54), VLOOKUP($C56,INDIRECT($K$55),10,FALSE)*VLOOKUP($C56,INDIRECT($K$55),11,FALSE)*VLOOKUP($K$54,$C$3:$N$8,12,FALSE)*NE(G$54,$K$54)}),0)+5+IF(AND($C$2,COLUMN(G56)>8),3,0)),FALSE))
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!