Forum Discussion
Formula Help - Like V Lookup but Multiple Criteria to Match
I am trying to create a calculator that can link pricing from one sheet to another. I am now stuck & have tried many different formulas but cannot get it to work. See "Shipping Calculator" Imag...
FikturFoxThank you so much for the response! I have attached the file.
I am unsure if this is possible to do or if my layout needs to be modified slightly to achieve this?
- Row 9 is for if Overnight Service is selected
It then needs to refer to column B-K to see which "Rate" to drop in for pricing
- Row 15 is for if Road Service is selected
It then needs to refer to column B-K to see which "Rate" to drop in for pricing
