Best Formula?
Best Formula?
The attached sheet shows what I'm trying to do. Column G shows the prices of all combinations of colums D, E and F. As a newbie I'm struggling with the appropriate formula to put in C32 to allow me to find the price. For example, 540 is the prices for 20 width, 40 length and made of brass. Any pointer would be greatly appreciated. I've been playing with INDEX and MATCH but not sure if it the right way to go.
- Attachments
-
- test.ods
- (10.1 KiB) Downloaded 88 times
libreoffice 5.4.1.2 on ubuntu 16.04
Re: Best Forumla?
- Attachments
-
- t97629.ods
- (10.61 KiB) Downloaded 74 times
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
Re: Best Forumla?
Thank you very much and sorry for the late reply. That link is extremely useful.
libreoffice 5.4.1.2 on ubuntu 16.04