VLOOKUP Help: if value is found, or if value is not found
Results 1 to 4 of 4

Thread: VLOOKUP Help: if value is found, or if value is not found

  1. #1
    New Member
    Join Date
    Mar 2019
    Location
    Melbourne, Australia
    Posts
    8
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Post VLOOKUP Help: if value is found, or if value is not found

    Hi Experts, Could you please help me complete this formula?
    I am looking up a value in one sheet, and if it is found then display it, if it is not found, then lookup in the second sheet, if it is found display it, and then so on and so forth.

    The example I have so far is:

    =IF(ISNA(VLOOKUP(A2,PFLISTINGS!A:H,3,0)),"",VLOOKUP(G3,PFHIGHEND!B:E,4,0))

    This is close, but not quite working. Is there a better way to achieve this?

  2. #2
    MrExcel MVP
    Moderator
    Peter_SSs's Avatar
    Join Date
    May 2005
    Location
    Macksville, Australia
    Posts
    40,456
    Post Thanks / Like
    Mentioned
    86 Post(s)
    Tagged
    19 Thread(s)

    Default Re: VLOOKUP Help: if value is found, or if value is not found

    Does this do what you want?

    =IFERROR(VLOOKUP(A2,PFLISTINGS!A:C,3,0),IFERROR(VLOOKUP(G3,PFHIGHEND!B:E,4,0),""))
    Hope this helps, good luck.
    Peter
    Excel 365 - Windows 10
    - Want to help your helpers by posting a small, copyable, screen shot directly in your post? Look here
    - If posting vba code, please use Code Tags - like this [code]Paste code here[/code] - or use the VBHTML Maker
    - Read: Forum Rules, Forum Use Guidelines, & FAQ

  3. #3
    New Member
    Join Date
    Mar 2019
    Location
    Melbourne, Australia
    Posts
    8
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: VLOOKUP Help: if value is found, or if value is not found

    Thank you - Yes it does.

  4. #4
    MrExcel MVP
    Moderator
    Peter_SSs's Avatar
    Join Date
    May 2005
    Location
    Macksville, Australia
    Posts
    40,456
    Post Thanks / Like
    Mentioned
    86 Post(s)
    Tagged
    19 Thread(s)

    Default Re: VLOOKUP Help: if value is found, or if value is not found

    Quote Originally Posted by darrenmccoy View Post
    Thank you - Yes it does.
    Cheers. Thanks for letting us know.
    Hope this helps, good luck.
    Peter
    Excel 365 - Windows 10
    - Want to help your helpers by posting a small, copyable, screen shot directly in your post? Look here
    - If posting vba code, please use Code Tags - like this [code]Paste code here[/code] - or use the VBHTML Maker
    - Read: Forum Rules, Forum Use Guidelines, & FAQ

Some videos you may like

User Tag List

Tags for this Thread

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
  •