CONCATENATE and VLOOKUP - How to get currency symbol?

Hi everybody!

I am really sort of getting crazy about this... I Read a lot about how to solve my problem, in this Forum as well, but non of this seems to work for me. Or maybe I am just making it wrong!^^

My formula is: =CONCATENATE(VLOOKUP(C23;Artikel!A3:I53;4;FALSE))
The result is (e.g.): 122,5
The result I would like to have is: 122,50 €

Could someone please tell me how to do this?
I read I should format my cell as text. Is that right?
But all examples I found are more simple formulas, so I am really not sure how mine should look like...

Thanks in advance for your help!

Lin

Hi,
Why are you using CONCATENATE when the only return you have is from the VLOOKUP? this could be shortened to simply

=VLOOKUP(C23;Artikel!A3:I53;4;FALSE)

Is your return value as you have advised with the comma? If so I'm not sure that will be able to been seen as a numeric value so I think it needs to be changed to a decimal point

Custom Format as

0.00 € (or 0,00 € .... local version)

Hi PFDave,

thank you soon much for your fast reply and easy solution!
To be honest I am not sure anymore why I was using CONCATENATE...
Seems to work perfectly without!

You made my day!

You're welcome HayLinFa

If that takes care if you thread please mark as solved and feel free to add to reputation should you see fit.

Dave