Hi guys
I've made a index-match formula. In my excel sheet in document 2 the function searches for values in document 1 and makes an output that is a corresponding horizontal value. See attached excel document.
However, I would like the formula to be extended. So it also transfers the cell color, i.e not only does the index-match function find the corresponding number, it also transfers the color of the cell (if it is colored ofc).
I used the following formula already for the index-match; =IFERROR(INDEX([1.xlsx]Ark1!$A$2:$A$11;MATCH(A6;[1.xlsx]Ark1!$B$2:$B$11;0));"")
Hope you guys can help me with the colortransfer.
Thanks in advance.
Christopher
Bookmarks