Thread: Index and Match
View Single Post
  #7   Report Post  
BillA BillA is offline
Junior Member
 
Posts: 4
Default

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!