I need an explanation for this formula:
=IF(G3="OnDemand",(VLOOKUP(CONCATENATE($B$1,C3,D3,E3," ","shared","hrs"),'AWS_8.1.17 Hardware'!B2:BT200000,11,FALSE))*730*J3*I3,IF($F3="Convertible No Upfront",(VLOOKUP(CONCATENATE(B$1,C3,D3,E3,H3,F3,"shared","hrs"),'AWS_8.1.17 Hardware'!B1:BR78560,11,FALSE)*730*J3),IF($F3="Standard No Upfront",(VLOOKUP(CONCATENATE(B$1,C3,D3,E3,H3,F3,"shared","hrs"),'AWS_8.1.17 Hardware'!B1:BR78560,11,FALSE)*730*J3),IF($F3="Standard All Upfront",(VLOOKUP(CONCATENATE(B$1,C3,D3,E3,H3,F3,"shared","quantity"),'AWS_8.1.17 Hardware'!B1:BR78560,11,FALSE)/12*J3)))))
Solved by G. D. in 26 mins