Does any one know what's wrong in this instant?
When I copy and paste "3 Months" to my spreadsheet, the formula in the cell next to it comes up #N/A. Only after deleting and adding the space between 3 and Months does the formula work. How can I make it read 3 Months first time ever time?
What I'm getting,
<tbody>
</tbody>The formula.
=(INDEX($E:$E,MATCH("3 Months",$E:$E,0)))
What I want to end up with, without having to delete and add the space.
<tbody>
</tbody>
When I copy and paste "3 Months" to my spreadsheet, the formula in the cell next to it comes up #N/A. Only after deleting and adding the space between 3 and Months does the formula work. How can I make it read 3 Months first time ever time?
What I'm getting,
3 Months | #N/A |
<tbody>
</tbody>
=(INDEX($E:$E,MATCH("3 Months",$E:$E,0)))
What I want to end up with, without having to delete and add the space.
3 Months | 3 Months |
<tbody>
</tbody>
Last edited: