Power Query Course in Spanish
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 4 of 4

Thread: I want my lookup to say 0 if it can't find anything - help!

  1. #1
    Board Regular
    Join Date
    Feb 2002
    Posts
    103
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I am trying to do a simple lookup, but if it can't find what I'm looking up it results in #N/A.

    I know it's possible, but just can't think how!

    Is it possible to put an IF statement with it?

    I know there are functions like ISERROR/ISNA etc, but I really just don't understand when these should be used, and have even been on the helps pages, but I still don't understand them !

    Thanks for your help

    Helen

  2. #2
    MrExcel MVP Aladin Akyurek's Avatar
    Join Date
    Feb 2002
    Location
    The Hague, NL
    Posts
    83,658
    Post Thanks / Like
    Mentioned
    33 Post(s)
    Tagged
    6 Thread(s)

    Default

    On 2002-04-10 06:30, Helen wrote:
    I am trying to do a simple lookup, but if it can't find what I'm looking up it results in #N/A.

    I know it's possible, but just can't think how!

    Is it possible to put an IF statement with it?

    I know there are functions like ISERROR/ISNA etc, but I really just don't understand when these should be used, and have even been on the helps pages, but I still don't understand them !

    Thanks for your help

    Helen
    Look at my post at:

    Look at this:
    http://www.mrexcel.com/board/viewtop...c=4277&forum=2

    Aladin


  3. #3
    New Member
    Join Date
    Apr 2002
    Posts
    9
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Good question,

    I assumed that:
    =IF((VLOOKUP(D4,$A$1:$B$10,2,FALSE))="#N/A",0,(VLOOKUP(D4,$A$1:$B$10,2,FALSE)))

    but it doesn't?

    Boz

  4. #4
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Austin, Texas USA
    Posts
    11,654
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    On 2002-04-10 09:39, bozack wrote:
    Good question,

    I assumed that:
    =IF((VLOOKUP(D4,$A$1:$B$10,2,FALSE))="#N/A",0,(VLOOKUP(D4,$A$1:$B$10,2,FALSE)))

    but it doesn't?

    Boz
    Boz, watch your data types... "#N/A" isn't the same as #N/A. Although I abhor this solution, the correct formula would be...

    IF(ISNA(VLOOKUP(D4,$A$1:$B$10,2,FALSE)),0,VLOOKUP(D4,$A$1:$B$10,2,FALSE))

    [ This Message was edited by: Mark W. on 2002-04-10 09:47 ]

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •