VLOOKUP to return percentage as "%"

Hi All,

I currently have a concatenate formula which uses several vlookups to produce a written annotation. One element of this annotation is a number expressed as a percentage e.g. 70%.

However, when the VLOOKUP formula picks up the 70%, it shows it as 0.7 rather than 70%, which is not the desired result. There are several permutations of the VLOOKUP which all use different percentages depending on the criteria, so entering the 70% as text is not an option. I also think I know how to achieve my result using an unnecessarily large formula, but I was hoping someone could provide a simple solution.

I don't quite understand what you mean. Currently the VLOOKUP looks like this:

&" - "&VLOOKUP(Journal!A12,'Master Data'!$B$5:$R$13,9,FALSE)

If I do as you say, my formula would look like the below:

&" - "&TEXT(VLOOKUP(Journal!A12,'Master Data'!$B$5:$R$13,9,FALSE),"%")

But the last part (red) is being rejected by Excel. Can you show me how to use the 'appropriate parameter for percentage' please?

==TEXT(Whatever, "0.0%")

Where the 0.0 indicates number of decimal places.

=&ROUND((VLOOKUP(<insert vlookup formula))*100,2) &"%"