Formula using INDEX and MATCH
 

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

Formula using INDEX and MATCH
 

Sky,

You cannot copy formatting with a formula...

Sorry...

Bernie
MS Excel MVP


"SKY" wrote in message
...
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

Formula using INDEX and MATCH
 

You will have to do 'Paste Special' twice.

first - Formats
second - Formula

Gary

"SKY" wrote in message
...
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