How to format a cell containing with vlook up formula?

[omer bayraktar]

Hello everybody,

I want to bring the result of this formula.=VLOOKUP(B1;AE:AI;3;0)&"-"&VLOOKUP(B1;AE:AI;5;0). 2 vlookups' results will be shown with a "-" sign. And this formula should also bring the same format of the table_array"s where the vlookup_value is looked for. A possible result is this: 3.500.000 $ - 16%

Is it possible? I want to see for example my company's 3.500.000 $ revenue comes from TV sales and this makes 30% of my whole revenue. 

Thanks in advance,

Ömer.

[#2]

Yes, that is possible. It might be better though to do two different vlookup formulas in tow different columns. the first column would be for the revenue and the second column would be for the %.

doing it that way would give you significantly more powerful functionality when analyzing that data.

Is there a reason why you want to have them together in one cell?