Mar 15 2021 06:30 AM
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
Mar 15 2021 06:35 AM
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.