| 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. |
| 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) | |||
Threaded Mode
