Match function problem
 

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.

Match function problem
 

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.

Match function problem
 

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

"SJC" wrote:

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.

Match function problem
 

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

"Peo Sjoblom" wrote:

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.