Thanks for the help everyone! I truly appreciate it.
What I ended up find that worked was
=INDEX($1:$1,MATCH(9.99999999999999E+307,2:2))
For comparison, I had been trying
=INDEX($1:$1,MATCH(1,2:2))
So for Song A (the first song) which is in row 2 (the titles are in row 1) if I use the above formula, it works. I don't know why searching for a very large number, vs searching for a 1 works.... but it does.
Thanks for the help!
|