Try


=INDEX(Sheet3!E:E,MATCH(Sheet2!C6,Sheet3!A:A,0))


--


Regards,


Peo Sjoblom




"SJC" wrote in message
...
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.