Formula using INDEX and MATCH

  • Thread starter Thread starter Guest
  • Start date Start date
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
 

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

Index Match Error 1
Using Index and Match Formula 2
MYSTERY: NESTED INDEX AND MATCH FUNCTIONS 29
Index and Match 3
Index Match Help 6
Index Match Inconsistencies 1
Convert Number to Text for Index/Match 1
Index and Match 2

Back
Top