Forum Discussion

clickdraw's avatar
clickdraw
Copper Contributor
Dec 06, 2017
Solved

New here...Looking forward to solving my questions with your help. Question #1

Hi All,   I work at a company that does custom fabrication using various type of plastic sheets, acrylic, ABS, PolyCarbonate,...etc. I am creating a form for our counter staff to use to calculate...
Formulas & Functions
Need Help
  • IngeborgHawighorst's avatar
    IngeborgHawighorst
    Dec 06, 2017

    Hello,

     

    the formula can be a lot shorter if you use the INDEX() function to get the rate. The syntax of index is

     

    =Index(table,row number, column number) 

     

    In your case you can use

     

    =INDEX(B12:D14,C9,F9)

     

    and then multiply with the value for SQ.Ft

     

    =INDEX(B12:D14,C9,F9)*I2

     

     

IngeborgHawighorst's avatar
IngeborgHawighorst
MVP
Dec 06, 2017

Hello,

 

the formula can be a lot shorter if you use the INDEX() function to get the rate. The syntax of index is

 

=Index(table,row number, column number) 

 

In your case you can use

 

=INDEX(B12:D14,C9,F9)

 

and then multiply with the value for SQ.Ft

 

=INDEX(B12:D14,C9,F9)*I2

 

 

  • clickdraw's avatar
    clickdraw
    Copper Contributor
    Dec 06, 2017
    Ok, I just tried your suggestion. WOW!!! I owe you a nice bottle of wine. Thank you so much. You've made my day.
    Cheers,
    Jeff
    • IngeborgHawighorst's avatar
      IngeborgHawighorst
      MVP
      Dec 06, 2017

      Thanks for the feedback. Glad it helped. 

  • clickdraw's avatar
    clickdraw
    Copper Contributor
    Dec 06, 2017

    Hi there,

     

    Thank you for your reply. Is this replacing the formula in cell K11?

    • clickdraw's avatar
      clickdraw
      Copper Contributor
      Dec 06, 2017

      Ok, I just tried your suggestion. WOW!!! I owe you a nice bottle of wine. Thank you so much. You've made my day.

      Cheers,

      Jeff

Resources