<div>
exactly what I was looking for. Thanks
</div>


<div>
<div class="content wysiwyg-content">
I need a Vlookup that will return either a Yes if Found or a No [instead on N/A] if not found and data I need to lookup is in a file in a folder.<br />
<br />
So ...i.e.<br />
<br />
I am using this but it returns the Reference rather than 'Yes'<br />
<br />
=IF(ISNA(VLOOKUP(C5,'G:\Da<wbr />ta\[ABC US.xlsx]Sheet1'!$A:$A,1,0)<wbr />),&quot;No&quot;,VLO<wbr />OKUP(C5,'G<wbr />:\Data\[AB<wbr />C US.xlsx]Sheet1'!$A:$A,1,0)<wbr />)<br />
<br />
Appreciate the help
</div>
</div>


I need a Vlookup that will return either a Yes if Found or a No [instead on N/A] if not found and data I need to lookup is in a file in a folder.

So ...i.e.

I am using this but it returns the Reference rather than 'Yes'

=IF(ISNA(VLOOKUP(C5,'G:\Data\[ABC US.xlsx]Sheet1'!$A:$A,1,0)),"No",VLOOKUP(C5,'G:\Data\[ABC US.xlsx]Sheet1'!$A:$A,1,0))

Appreciate the help

Vllokup question

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