Hi,

Can you provide a file for us too look at?

@ charlesdh

hi thanks for your help, I uploaded the file with the code and some data as an example.

@ excelledsoftware

thanks you for the help, unfortunately I cannot simply concatenate a $ or € because they are variables the code must be able to read the format and report it accordingly in the concatenation

@ macropod

Thanks a lot for your interest, you suggestion is to technical for me, how would you exactly integrate that in the code that I posted please?
I didn't write the code myself entirely , I basically only added the two formulas: concatenation and Index/Match.

Attached Files

SAMPLE.xlsm (121.8 KB, 12 views)