Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
INDEX MATCH formula | Excel Worksheet Functions | |||
INDEX and MATCH in one formula... | Excel Worksheet Functions | |||
lookup? Index? match? formula | Excel Discussion (Misc queries) | |||
Index and Match Array formula | Excel Worksheet Functions | |||
How to add in an array formula if iisna index match | Excel Worksheet Functions |