Forum Discussion
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...
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?
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?