I have to call the text value of cell A1 using index+match function to A2.
A1 contains two fonts – Calibri (11) and Times New Roman (20). I want to get the same text format in cell A2.
How can I do that without VBA?
You can copy and paste format, or if there's a specific value you want to associate with that text format, you can use conditional formatting. Anything else, you'll need VBA.