Formula HELP possible index and match

[Joneye]

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.

 

[Andrew Poulsom]

If you remove the g you can use VLOOKUP.

 

[VoG]

Maybe like this

Excel Workbook
	A	B	C	D
1	1023g	0.53	Weight	Cost
2			600g	0.47
3			1000g	0.53
4			2000g	0.59
5			3000g	0.65
6			4000g	0.71
Sheet2

 

[Andrew Poulsom]

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

 

[Joneye]

Yep thanks guys and happy east you have help out big time again.