Adding text to a number only result.

[Zagra147]

Win 7
XL 2010

I am usung the following formula to extract data from an Excel database where the result may be text or number extracted from column 3.
If 'A' is chosen the result will be a number representing % AbV. Choosing 'F' will result in text only.

=VLOOKUP($D20,CHOOSE(MATCH(LEFT($D20,1),{"A","F"},0),[Food_List_2011.xls]Alcohol!$D$9:$N$2000,[Food_List_2011.xls]Foods!$D$6:$AA$2000),3,FALSE))

I wish to add the text '% AbV' to the number only result and not to the text result.

While a 2010 specific solution would be appreciated, I may have to export the file to pre-2007 users.

Any suggestions?

TIA

Alan

[DonkeyOte]

This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

Thread Closed.