# Formula HELP possible index and match

#### Joneye

##### Well-known Member
The table below shows a cost, this cost needs to be selected by how much something weighs.

Example Cell A user inputs "1023g" then cell B must automatically generate a cost of £0.53.

Weight Cost
600g £0.47
1000g £0.53
2000g £0.59
3000g £0.65
4000g £0.71

ANY HELP is appreciated.

### Excel Facts

Create a Pivot Table on a Map
If your data has zip codes, postal codes, or city names, select the data and use Insert, 3D Map. (Found to right of chart icons).

#### Andrew Poulsom

##### MrExcel MVP
If you remove the g you can use VLOOKUP.

#### VoG

##### Legend
Maybe like this

Excel Workbook
ABCD
11023g0.53WeightCost
2600g0.47
31000g0.53
42000g0.59
53000g0.65
64000g0.71
Sheet2

#### Andrew Poulsom

##### MrExcel MVP
LOOKUP won't work for eg 650g because the lookup range is not sorted ascending.

#### Joneye

##### Well-known Member
Yep thanks guys and happy east you have help out big time again.

Replies
4
Views
263
Replies
0
Views
221
Replies
6
Views
337
Replies
0
Views
540
Replies
2
Views
227

1,195,699
Messages
6,011,188
Members
441,593
Latest member
kwest3904

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back