Based on the formula I am using (see below), how could I reference the cell
with the superscript a? I tried concatenate, but received N/A.

"Ken Hudson" wrote:

Hi TJ,
One way...
Enter the letter "a" in a superscript format in an unused, unseen cell,
e.g. ZZ1.
Go to ZZ1, select Format Cells... Font and check the superscript box.
The refer to ZZ1 in your formula.
HTH
--
Ken Hudson


"TJ" wrote:

I am using the index formula to bring data to a sheet. I want to add a
superscript to text that will be adjoined to the formula.

=index(holdings!$b$4:$b$120,match($b9,holdings!$a$ 4:$a$120,0))&"(a)"

How do I superscript (a) in this case?