Stop #N/A appearing after a vlookup
Solved/Closed
Related:
- Stop #N/A appearing after a vlookup
- Whatsapp messages are not appearing in chronological order ✓ - WhatsApp Forum
- Vlookup subtraction formula ✓ - Office Software Forum
- Contact not appearing in whatsapp - Guide
- Disable search history appearing in address bar - Guide
- Transfer data from one excel worksheet to another automatically vlookup - 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))
