IFNA with VLOOKUP

[An Toe Knee]

I'm performing a VLOOKUP between two tables.

If the returning cell is blank, I want a blank to return also (to avoid the 0/01/1900).

If the lookup value does not appear I want the field to show "Not Found" instead of #N/A

I have had success with both VLOOKUP and IFNA, they work, however, the forumula I am using still returns #N/A despite successfully performing the VLOOKUP and returning the blank from the first arguement. As below :

=IF(VLOOKUP([A,Table2,5,FALSE)="","",IFNA(VLOOKUP(A,Table2,5,FALSE),"Not Found"))

Any advice would be awesome!

 

[cooper645]

this should return the date if it exists, ""(blank) if it is blank, and Nothing Found when the lookup value doesn't exist

=IFNA(IF(VLOOKUP(Q3,Table2,5,0)=0,"",VLOOKUP(Q3,Table2,5,0)),"Nothing Found")

chang Q3 to your referenced lookup cell.


Coops