Vllokup question

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
JagwarmanAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
Rgonzo1971Connect With a Mentor Commented:
HI,

pls try
=IF(ISNA(VLOOKUP(C5,'G:\Data\[ABC US.xlsx]Sheet1'!$A:$A,1,0)),"No","Yes")

Open in new window

Regards
0
 
JagwarmanAuthor Commented:
exactly what I was looking for. Thanks
0
All Courses

From novice to tech pro — start learning today.