required formula for 3 base factors

[GVN KUMAR]

sir
this previous quarry answer given by bosco_ypi only 1 factory formula written


required full formula length formula

thank you sir

 

[AlanSidman]

I used lookup tables in power query to achieve your needs. Look at the attached. Change your lookups and then click on the Refresh All Icon on the Data Tab. Add to your source table and then click on the Refresh All to update.

 

[bosco_yip]

E14:

=IFERROR(LOOKUP(9^9,D3:D12/(A3:A12=B15)/(B3:B12=B16)/(C3:C12=B17)),"")