Formatting Currency in VLOOKUP formula

[tiffanywest12]

I have this formula and I am trying to get the currency part that is pulled from another sheet to populate as currency in the VLOOKUP formula. What am I missing?

=("Your purchase donated $"&IFERROR(VLOOKUP(rngInvoice,InvoicesMain,9,FALSE),"")&" to Alex's Lemonade Stand")

This exact formula populates to look like "Your purchase donated $5.6 to Alex's Lemonade Stand" I need to change the dollar amount to be formatted correctly

 

[RasGhul]

Does this work for you?

=("Your purchase donated "&IFERROR(VALUE(TEXT(VLOOKUP(rngInvoice,InvoicesMain,9,FALSE),"$#.##0")),"")&" to Alex's Lemonade Stand")