Match function problem

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

SJC - 14 Sep 2007 16:52 GMT

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.

Reply to this Message

Peo Sjoblom - 14 Sep 2007 17:03 GMT

Try

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

Signature

Regards,

Peo Sjoblom

>I have a workbook in which one worksheet contains data for several
>companies,
[quoted text clipped - 12 lines]
> I have tried changing the cell format, rewriting the formula, and haven't
> found a solution. Any help would be greatly appreciated.

Reply to this Message

SJC - 14 Sep 2007 18:02 GMT

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

> Try
>
[quoted text clipped - 16 lines]
> > I have tried changing the cell format, rewriting the formula, and haven't
> > found a solution. Any help would be greatly appreciated.

Reply to this Message

bj - 14 Sep 2007 17:06 GMT

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

> 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.
[quoted text clipped - 7 lines]
> I have tried changing the cell format, rewriting the formula, and haven't
> found a solution. Any help would be greatly appreciated.

Reply to this Message