Logo 
Search:

MS Office Forum

 Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

vlookup and the value #N/A

  Asked By: Abarrane    Date: Oct 16    Category: MS Office    Views: 680
  

I use the formulas "vlookup" and "hlookup" with the parameter "false".
When there is the value #N/A, I would like that it is replaced by
other string of character.
For to make it, I have used the conditional "if" with the following
way:
"if(vlookup(*,*,*,false)="#N/A","...","...")".
It dosen't work. It still displays "#N/A".

Does anyone know how to make?

Share: 

 

3 Answers Found

 
Answer #1    Answered By: Kim Coleman     Answered On: Oct 16

Look at the function ISNA
See Help for 'IS Functions'

if(ISNA(vlookup(*,*,*,false)),"...","...")

 
Answer #2    Answered By: Burke Martin     Answered On: Oct 16

it is better to use the iserror() function as it will handle more exceptions

 
Answer #3    Answered By: Rolando Reed     Answered On: Oct 16

Use this "=if(iserror(vlookup(*,*,*,false)),"...",vlookup(*,*,*,false))

 
Didn't find what you were looking for? Find more on vlookup and the value #N/A Or get search suggestion and latest updates.




Tagged: