VLOOK UP Issue - Works on some cells, but not on others!

Hi Everyone,

I have sat for days and days trying to figure this issue out and it is beyond me.

I have created a mock spreadsheet, which I have attached. This mimics the problem I am having with vlookup. So basically, we have a product weight, on which we add 0.015kg to get postage weight. We then use this postage weight, to vlookup the postage cost.

So this seems to work for some weights, but not others. Ie. For postage weight of 0.225kg it returns #N/A, but for many other it would actually return a weight. In the 0.225kg, if I type in 0.225kg instead of having this generated as a formula, then it returns a postage cost. However, for the others even with the formula to generate the postage weight it still populated a postage cost.

It sounds confusing, but please review the spreadsheet, it is very easy to get your head around. I have tried everything, from changing formatting of cells, to trimming it etc. Ultimately we want it to work for all cells with formula. I am completely baffled as to why this is happening.

Thank you in advance.

Thanks so much, this works!

However, is there anyway, I can get the postage weight which already is being populated by a formula to round instead?

Hello,

Thanks for this, I managed to crack this one myself, but you are a star! Much appreciated.