Hello!
I am trying to get excel to return a value and a format of a cell from one sheet to another. I am able to get it to return only the value using formulae like
=INDEX('Master Comp Matrix '!$D$10:$ET$46,MATCH('Equip Comp Matrix- A1-E'!BA13,'Master Comp Matrix '!$D$10:$D$46,0),MATCH('Equip Comp Matrix- A1-E'!$BH$10,'Master Comp Matrix '!$D$7:$ET$7,0))
But this does not return the format which is not dependent on the value at all.
I am not a strong vba user and would greatly appreciate any help on this!! Thanks in advance!!
Bookmarks