E elsmith9035768 Member Oct 1, 2018 #1 I have formulas in columns I, K, and L already set up, but have to complete the rest of the steps manually. I was wondering if this could be formulated to be completed automatically after I enter the amount in B3. See example. Attachments Auto complete table.xlsx 29.3 KB · Views: 5
I have formulas in columns I, K, and L already set up, but have to complete the rest of the steps manually. I was wondering if this could be formulated to be completed automatically after I enter the amount in B3. See example.
H Haz Active Member Oct 1, 2018 #2 Formula in J5:J19 =IF(LOOKUP($B$3,$N$5:$N$19)=N5,$B$3,"") In C6:C7 and E7 use MAX =MAX($I$5:$I$19) =MAX($K$5:$K$19) And in E6, rounded to 5000 =MROUND(MAX($L$5:$L$19),5000)
Formula in J5:J19 =IF(LOOKUP($B$3,$N$5:$N$19)=N5,$B$3,"") In C6:C7 and E7 use MAX =MAX($I$5:$I$19) =MAX($K$5:$K$19) And in E6, rounded to 5000 =MROUND(MAX($L$5:$L$19),5000)
