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
Bookmarks