Index and Match Formula Error

I attached a sample file of my question, but I am getting a #NA error on a Index and Match Formula. I have reviewed many other threads trying to find a solution to this issue, but no luck so far.
There are two tabs in the attached file. Raw Data is a report copied and pasted directly from IEX with names change and other data removed of course. Reporting Data is the tap I would like my value listed beside each name. The value I need reported is on in column 6, but it is 10 rows below the name.

Here is the formula I am working with: =INDEX('Raw Data'!$A$1:$F$26482,MATCH(A2,'Raw Data'!$F$1:$F$26482,0)+10,6)


I am willing to bet I missed something very simple, but any help is greatly welcomed.