Lookup Functions to bring Font and textColor

%3CLINGO-SUB%20id%3D%22lingo-sub-2210938%22%20slang%3D%22en-US%22%3ELookup%20Functions%20to%20bring%20Font%20and%20textColor%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2210938%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhile%20I%20am%20using%20Vlookup%20or%20Index%20match.%20I%20am%20only%20getting%20corresponding%20lookup%20values%20not%20their%20font%20color%20or%20text%20format%20is%20there%20any%20possibility%20that%20we%20could%20able%20to%20get%20those%20things%20to.%20I%20know%20we%20could%20use%20VBA%20but%20need%20know%20if%20there%20is%20any%20formula%20or%20any%20other%20method%20to%20do%20it%20without%20VBA.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks.%3C%2FP%3E%3CP%3ENA%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2210938%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

Hello,

 

While I am using Vlookup or Index match. I am only getting corresponding lookup values not their font color or text format is there any possibility that we could able to get those things to. I know we could use VBA but need know if there is any formula or any other method to do it without VBA.

 

Thanks.

NA

1 Reply

@Naveed1002 

No, formulas work with cell values, not with cell properties like color. To work with properties you need VBA, your own or already built functions.