turtlepokerman
New Member
- Joined
- Jun 18, 2012
- Messages
- 28
Greetings World,
I am using Excel 2010.
I am trying to use a Match function to find exact matches to strings in a pdf file that I extracted using text import wizard. The only way that I can get the formula to give me the correct result is to manually retype the Match function's lookup value's reference cell.
I have tried the following solutions to fix the problem without completely retyping the cell:
1. Recalculate the formula Result
2. Change formatting of cell from General -> Text -> General
3. Hit Enter on the reference cell and formula cell
4. Turning on/off Automatic Calculation Results
Example:
<tbody>
</tbody>
****** id="cke_pastebin" style="position: absolute; top: 246px; width: 1px; height: 1px; overflow: hidden; left: -1000px;">
<tbody>
</tbody></body>Any help is appreciated as I have over 1000 rows of data.
I am using Excel 2010.
I am trying to use a Match function to find exact matches to strings in a pdf file that I extracted using text import wizard. The only way that I can get the formula to give me the correct result is to manually retype the Match function's lookup value's reference cell.
I have tried the following solutions to fix the problem without completely retyping the cell:
1. Recalculate the formula Result
2. Change formatting of cell from General -> Text -> General
3. Hit Enter on the reference cell and formula cell
4. Turning on/off Automatic Calculation Results
Example:
Text Import Data | My Strings | Formula | Result |
15EZ-73A | 15FX-72A | =MATCH(B2,$A$2:$A$3,0) | #N/A |
15FX-72A | 15EZ-73A | =MATCH(B3,$A$2:$A$3,0) | #N/A |
<tbody>
</tbody>
****** id="cke_pastebin" style="position: absolute; top: 246px; width: 1px; height: 1px; overflow: hidden; left: -1000px;">
=MATCH(B2,$A$2:$A$3,0) |
<tbody>
</tbody>