adding text to a reference

[Por2gal]

I am trying to add a text after a reference function. I can add a text before a reference function by preceding the function with an apostrophe; e.g ="Please use: "&IFERROR(VLOOKUP(VLOOKUP(rngInvoice,'Sales invoice tracker for Jax.xlsx'!InvoicesMain[#Data],2,FALSE),CustomerList,3,FALSE),""""). However, how do i add a text after this reference function by adding "+ joining fee".
Please Help

[dominicb]

Good morning Por2gal

You can add free text to the end of a formula without affecting its functionality by using the N function, thus :

Please Login or Register  to view this content.

You formula above would become :

Please Login or Register  to view this content.

HTH

DominicB

[Por2gal]

hi there HTH, i just get a #value! when your formula is applied, how do i work around this? thank you