try entering with CRTL SHIFT enter
Sorry I posted the wrong formula, please check the below formula, I tried using the CRTL SHIFT ENTER, but formula only calcuting right the first cell of range
=IF(Yield!A757:A1020=Sun!A131,Sun!B131/Sun!K131,IF(Yield!A1:A756=Sun!A131,(Sun!B131+Sun!P131)/Sun!K131,0))
this is due to cell refrances, can you show us a sample worksheet?
Product code always stays same, if new product we just add the product code and standard yield.are the product codes ever the same?
See if this works
=(B131+ISNUMBER(MATCH($A131,Yield!$A$1:$A$756,0))*$P131)/$K131
M.