Unanswered: Formula Assistance (or maybe look-up)?
Can someone explains something in excel for me?
I'm working on a sales quotation format that has all the pricing in the background. Inputs some information via numerical input, other choices are selected from drop down menus. I've managed to get most of the "IF" formulas correct, however there is one cell I am stumped with. What needs to be displayed is the result of 2 drop down menus.
based on my little table attached, if I have selected "50 Kg" from one drop down menu, and "Singapore" from the other one, I would want the cell that I am working on to know it should display "110".
Thanks Mike. I got a slightly different solution elsewhere that worked, ignoring the table I posted since I only created that to demonstrate my problem, what was provided to me was a INDEX and MATCH SOLUTION.