<div>
=IF(R34=&quot;Match&quot;,&quot;&quot;,IF(ISER<wbr />ROR(VLOOKU<wbr />P(LEFT(D34<wbr />,4),MatchD<wbr />ata!L:S1,8<wbr />,TRUE)),&quot;N<wbr />OT FOUND&quot;,VLOOKUP(LEFT(D34,4)<wbr />,MatchData<wbr />!L:S1,8,TR<wbr />UE)))<br />
<br />
You can try this, you need to specifiy exact match with TRUE
</div>


=IF(R34="Match","",IF(ISERROR(VLOOKUP(LEFT(D34,4),MatchData!L:S1,8,TRUE)),"NOT FOUND",VLOOKUP(LEFT(D34,4),MatchData!L:S1,8,TRUE)))

You can try this, you need to specifiy exact match with TRUE

<div>
=IF(R34=&quot;Match&quot;,&quot;&quot;,VLOOKUP<wbr />(VALUE(LEF<wbr />T(D34,4)),<wbr />MatchData!<wbr />L:S,8,FALS<wbr />E))<br />
<br />
I think you need the VALUE command to properly extract a numeric to satisfy the VLOOKUP.
</div>


=IF(R34="Match","",VLOOKUP(VALUE(LEFT(D34,4)),MatchData!L:S,8,FALSE))

I think you need the VALUE command to properly extract a numeric to satisfy the VLOOKUP.

<div>
by the way, it's much easier for us to work on an example sheet (with no confidential data on it, of course) if you can attach them...
</div>


by the way, it's much easier for us to work on an example sheet (with no confidential data on it, of course) if you can attach them...

<div>
<div class="content wysiwyg-content">
I am using this formula that works fine until it can't find wjat it is looking for<br />
<br />
=IF(R34=&quot;Match&quot;,&quot;&quot;,VLOOKUP<wbr />(LEFT(D34,<wbr />4),MatchDa<wbr />ta!L:S,8,)<wbr />)<br />
<br />
but if it can't find it returns #N/A<br />
<br />
I have tried to add ISERROR but can't get it to work.<br />
<br />
Please help instead of #N/A I want it to say Not Found<br />
<br />
Thanks
</div>
</div>


I am using this formula that works fine until it can't find wjat it is looking for

=IF(R34="Match","",VLOOKUP(LEFT(D34,4),MatchData!L:S,8,))

but if it can't find it returns #N/A

I have tried to add ISERROR but can't get it to work.

Please help instead of #N/A I want it to say Not Found

Thanks

excel formula

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