I'm trying to create a function where if a value is found in a table then it should return "Yes" and if not return "No". When I used this function it returns Yes if found but "#N/A" if not. What am I doing wrong?
=IF(VLOOKUP(E2,A1:A178,1,FALSE)=E2, "Yes", "No")
The value in E2 is the value I'm trying to match.
Bookmarks