Stop #N/A appearing after a vlookup
Solved/Closed
Related:
- Stop #N/A appearing after a vlookup
- Disable search history appearing in address bar - Guide
- What symbol typically appears to the left of a secure site? - Guide
- Transfer data from one excel worksheet to another automatically vlookup - Guide
- Appearing offline on whatsapp - Guide
- Ubuntu screen keyboard not appearing - Guide
2 responses
venkat1926
Posts
1863
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
811
Jul 22, 2009 at 08:42 PM
Jul 22, 2009 at 08:42 PM
this may of help to you
=if (isNA(vlookup(...........)),"",vlookup(.........))
take care of the number of brackets. sometimes excel itself will help you with suggestions.
example
=IF(ISNA(VLOOKUP(A13,A1:B4,2,FALSE)),"",VLOOKUP(A13,A1:B4,2,FALSE))
=if (isNA(vlookup(...........)),"",vlookup(.........))
take care of the number of brackets. sometimes excel itself will help you with suggestions.
example
=IF(ISNA(VLOOKUP(A13,A1:B4,2,FALSE)),"",VLOOKUP(A13,A1:B4,2,FALSE))
