use source formatting in an index match

[almostgenius]

Hi,

I have this formula that people of this forum have generously helped me get correct. i'm wondering if there is a way to make the formula use the source formatting when it returns the data? so that my text comes out in the same style of the source cells?

Please Login or Register  to view this content.

[FDibbins]

i'm wondering if there is a way to make the formula use the source formatting when it returns the data

No, sorry, formulas deal with data, formatting is cosmetic, not data. Cant you just format the destination cell normally/manually? Or perhaps consider Conditional Formatting? What is the format, can it c=hange?

[almostgenius]

Hi,
thanks for the help.
i think that as there is a random number of cels being returned each time conditional formatting might be the way to go, so I'm guessing that what conditional formatting means is that i can group select all the cells in the sheet and apply formatting that says something like "if the cell contains any of these 3 or 4 words use larger bold font" this would create sort of headings that stand out for the different types of data sets.

[FDibbins]

group select all the cells in the sheet and apply formatting that says something like "if the cell contains any of these 3 or 4 words use larger bold font"

yes, pretty much. What exactly are you trying to do?