Forum Discussion

omer bayraktar's avatar
omer bayraktar
Copper Contributor
May 10, 2017

How to format a cell containing with vlook up formula?

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.

office 365
  • Zachary Grotovsky's avatar
    Zachary Grotovsky
    Brass Contributor
    May 10, 2017
    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?

Resources