Match function problem

[Guest]

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.

 

[Peo Sjoblom]

Try


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


--


Regards,


Peo Sjoblom

 

[Guest]

What do you get with just using the match portion as your equation?

 

[Guest]

Worked perfectly, thanks so much. I didn't think to make that change.