Hi,

No, currency.

I think I have figured it, sorry. The formula contained SUBSTITUTE which when removed now returns the correct value?

I can get around this by using the correct terminology in the look up table.

Any ideas why this happens for future reference?