<div>
HI<br />
<br />
Do you mean?<br />
<br />
=IF(ISNA(VLOOKUP(TRIM(A1),<wbr />$A$1:$A$15<wbr />,1,FALSE))<wbr />, &quot;No&quot;, &quot;Yes&quot;)<br />
<br />
Regards
</div>


HI

Do you mean?

=IF(ISNA(VLOOKUP(TRIM(A1),$A$1:$A$15,1,FALSE)), "No", "Yes")

Regards

<div>
<div class="content wysiwyg-content">
Heyas,<br />
<br />
I know the standard Vlookup comparison formula e.g.<br />
<br />
=IF(ISNA(VLOOKUP(A1,$A$1:$<wbr />A$15,1,FAL<wbr />SE)), &quot;No&quot;, &quot;Yes&quot;)<br />
<br />
My query how do you make the standard formula ignore spacing.<br />
<br />
Thank you.
</div>
</div>


Heyas,

I know the standard Vlookup comparison formula e.g.

=IF(ISNA(VLOOKUP(A1,$A$1:$A$15,1,FALSE)), "No", "Yes")

My query how do you make the standard formula ignore spacing.

Thank you.

Vlookup Compare Values Between Columns - Ignore Spacing

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