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: 1871

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
It dosen't work. It still displays "#N/A".

Does anyone know how to make?



3 Answers Found

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

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


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.