I have a workbook in which one worksheet contains data for several companies,
and the second worksheet pulls the data into a report using data validation.
I am using an index/match formula to pull the name of the company that shows
up on the report, which worked fine for quite some time. However, now, it is
returning a 'zero' instead of inserting the text. Any ideas on how to
correct?

The formula I am using is: =INDEX(Sheet3!E:E,MATCH(Sheet2!C6,Sheet3!A:A),0)

I have tried changing the cell format, rewriting the formula, and haven't
found a solution. Any help would be greatly appreciated.