Hi Pete,

That is very impressive, it is exactly what I am looking for. May I ask in the last part of the formula RIGHT(B10-1)*4+2)=0,"US","EUR"), what does 4 and 2 refer to? The excel sheet I posted is just a dummy version and I am hoping to recreate the formula in the official excel book.

So grateful for your help!

Michelle