Stop #N/A appearing after a vlookup
Solved/Closed
Related:
- Stop #N/A appearing after a vlookup
- Iserror function in excel with vlookup - Guide
- Contact not appearing in whatsapp - Guide
- Appearing offline xbox - Guide
- Transfer data from one excel worksheet to another automatically vlookup - Guide
- Appearing offline on whatsapp - Guide
2 responses
venkat1926
Posts
1863
Registration date
Sunday 14 June 2009
Status
Contributor
Last seen
7 August 2021
811
22 Jul 2009 à 20:42
22 Jul 2009 à 20:42
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))
