An Toe Knee
New Member
- Joined
- Jan 24, 2018
- Messages
- 1
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!
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!