I have a table of several text values such as "12-1", "12-3", etc and was
trying to run Index on it , however I was unable to get a value. All it
does is return the formula when I hit enter.

Any help will be appreciated.