Formula using INDEX and MATCH

G

Guest

I am copying data to another worksheet based upon the following formula.

=INDEX('Revamp Master'!$A:$C,MATCH($D2,'Revamp Master'!$B:$B,0),1)

When data gets copy, the original format set on the text are gone, that
means the copied data is plain in black. The original text contents format
like strike through on some characters but the strike through does not get
carry to the destination cell.

Any suggestion to enhance this formula.

SKY
 
B

Bernie Deitrick

Sky,

You cannot copy formatting with a formula...

Sorry...

Bernie
MS Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Using Index and Match Formula 2
Index Match Error 1
MYSTERY: NESTED INDEX AND MATCH FUNCTIONS 29
Index Match Inconsistencies 1
Index and Match 3
Index Match Help 6
Index and Match 2
Index Match on Columns and Rows 0

Top