VickyPalmer
New Member
- Joined
- Mar 12, 2021
- Messages
- 3
- Office Version
- 2019
- Platform
- Windows
Hello, I'm hoping someone could help me with the following problem please. I have a excel sheet that has the following columns: Country, Weight from, Weight to, Cost. eg United States, 1 (Kg), 1.5 (Kg), $5.
The spreadsheet has multiple countries, different weight from and to and then the cost. I need to be able to look up a specific country, then find the right weight category and retrieve the value associated with that.
Eg look up United States for 1.11Kg it will need to first identify united states then identify that 1.11Kg is between the values 1Kg--1.5Kg and retrieve the value next to that.
I've tried multiple INDEX match formula's vlookup true etc but cannot identify a formula that would work, any help will be much appreciated.
Thank you
The spreadsheet has multiple countries, different weight from and to and then the cost. I need to be able to look up a specific country, then find the right weight category and retrieve the value associated with that.
Eg look up United States for 1.11Kg it will need to first identify united states then identify that 1.11Kg is between the values 1Kg--1.5Kg and retrieve the value next to that.
I've tried multiple INDEX match formula's vlookup true etc but cannot identify a formula that would work, any help will be much appreciated.
Thank you