| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| index match array function-returning only first match, need last. | Excel Worksheet Functions | |||
| Match function problem | Excel Worksheet Functions | |||
| MATCH function problem | Excel Discussion (Misc queries) | |||
| Problem with match function | Excel Discussion (Misc queries) | |||
| Match Function Problem - Won't Find Certain Numbers | Excel Discussion (Misc queries) | |||
Linear Mode
