Adding text to number only answer.

[Zagra147]

Win 7
XL2010
I am using the following to extract text and numerical data from a databse (column 3 on different worksheets).

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

When the answer is numerical only (when 'A' is selected, column 3 contains % AbV data), I wish add the text '% AbV' to the answer.
When 'F' is selected, the answer is text only.
If I use '&"% AbV"', it is added to both text and number answers.

Any suggestions?

Although a 2010 specific reply would be appreciated, I may have to export this file to pre-2007 users.

TIA

Alan

[DonkeyOte]

Perhaps:

Please Login or Register  to view this content.

though of course at that point the result will be a text string irrespective of whether A/F is active.

[Marcol]

You could try formating the recieving cells, but check if the formula is returning a number and not a string.
Format > Custom

Please Login or Register  to view this content.

Alter the digits part to suit your needs.
e.g.

Please Login or Register  to view this content.

This will remove the decimal digits

Hope this helps

[Zagra147]

Thanks, DonkeyOte.

That works fine.

Regards,

Alan