School Business Manager

Michael O'Flaherty

<div>
Thank you Subodh and Saqib<br><br>Each of your comments solved it for me.<br><br>Thanks<br>Michael
</div>


<div>
You're welcome, Michael! Glad we could help.
</div>


<div>
<div class="content wysiwyg-content fr-view">
I have a complex formula that gives me the result I want on one sheet.<br>On another I have typed text identical to the result of the formula, but when I paste the value of the formula into a cell its contents are preceded by an apostrophe causing the VLOOKUP to fail.<br><br>I have attached the file with notes describing the problem on sheet Notes in that file<br><br>Thanks<br>Michael<br><a href="https://filedb.experts-exchange.com/incoming/2021/08_w33/1569237/EE-why-does-formula-result-in-diffe.xlsx" rel="ugc">EE why does formula result in different answer to a typed in cell with the same text as the formula result.xlsx</a>
</div>
</div>


EE-why-does-formula-result-in-diffe.xlsx


I have a complex formula that gives me the result I want on one sheet.
On another I have typed text identical to the result of the formula, but when I paste the value of the formula into a cell its contents are preceded by an apostrophe causing the VLOOKUP to fail.
I have attached the file with notes describing the problem on sheet Notes in that file
Thanks
Michael
EE why does formula result in different answer to a typed in cell with the same text as the formula result.xlsx


Thank you Subodh and Saqib
Each of your comments solved it for me.
Thanks
Michael


You&#39;re welcome, Michael! Glad we could help.

My VLOOKUP does not work because cells with a formula that give a result identical to a cell with typed text are not the same

Microsoft Office is an integrated suite of applications that includes Outlook, Word, Excel, Access, PowerPoint, Visio and InfoPath, along with a number of tools to assist in making the individual components work together. Coding within and between the projects is done in Visual Basic for Applications, known as VBA.

Microsoft Office

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.