Share via

iferror not working

Anonymous
2015-09-11T08:48:45+00:00

Hello,

I have a similar problem in that I am using Iferror and vlookup and it works in some columns and then it others it doesn't. It just repeats the same figure down or makrs them all blank. if I remove the if error then and just use vlookup , the formula works but I have all the N/A?s

IFERROR(VLOOKUP(D2,'IM file'!C:BE,54),""). This works

=VLOOKUP(D2,'IM file'!C:AB,25,) THis works but IFERROR(=(VLOOKUP(D2,'IM file'!C:AB,25),"") doesn't

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

4 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Vijay A. Verma 104.9K Reputation points Volunteer Moderator
    2015-09-11T09:30:57+00:00

    Use following for correct results -

    =IFERROR(VLOOKUP(D2,'IM file'!C:AB,25,0),"")

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments
  2. Anonymous
    2015-09-11T11:27:37+00:00

    thanks thats worked for me

    Was this answer helpful?

    0 comments
  3. Anonymous
    2015-09-11T09:17:41+00:00

    Hi Vijay,

    I had tried that but It doesnt return the correct results. It wil populate the N/A as blanks but then it will return the wrong results. So for the file I am working on I have about 2000 lines that should be populated and the rest would be blank. This is just returning about 5 or 6 results repeatedly . It doesnt make sense

    Was this answer helpful?

    0 comments
  4. Vijay A. Verma 104.9K Reputation points Volunteer Moderator
    2015-09-11T09:04:22+00:00

    "=" sign can not be inside in any formual not only for IFERROR..

    Hence, you have to write - 

    =IFERROR(VLOOKUP(D2,'IM file'!C:AB,25),"")

    Was this answer helpful?

    0 comments