cell format

[Zalabya83]

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

 

[Special-K99]

I dont completely understand.

VLOOKUP / HLOOKUP / LOOKUP retrieve values. They do not retrieve formats.

Maybe supply some examples.

 

[Zalabya83]

i’m trying to use a method i saw which was dynamic interactive dashboard using drop down list so i created the same but i used a slicer instead of drop down list and it worked however the cell value is not reflected from the original with its format

i use index and vlookup

 

[Special-K99]

I dont know much about dashboard and slicer