hello, i would like to know if i can preserve excel cell format when using any lookup formula, i have a chart and want to view sales by quantity/value or percentage based on slicer selection.
the method that i’m using currently allows me to view any of the above with 1 type of format not based on the original cell format
the method that i’m using currently allows me to view any of the above with 1 type of format not based on the original cell format