Thread: 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

Sky,

You cannot copy formatting with a formula...

Sorry...

Bernie
MS Excel MVP


"SKY" <SKY@discussions.microsoft.com> wrote in message
news:206EF998-BA13-4D19-9938-5A5A08E4A8BB@microsoft.com...
>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
>

You will have to do 'Paste Special' twice.

first - Formats
second - Formula

Gary

"SKY" <SKY@discussions.microsoft.com> wrote in message
news:206EF998-BA13-4D19-9938-5A5A08E4A8BB@microsoft.com...
>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
>