Forum Discussion
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...
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
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
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
Cheers,
Jeff
Thanks for the feedback. Glad it helped.