Results 1 to 5 of 5

Thread: VLOOKUP Not Showing Result ?

  1. #1
    Board Regular
    Join Date
    Jan 2019
    Posts
    58
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default VLOOKUP Not Showing Result ?

    It's a pretty simple function - just look down the column range and display the cell that is not blank...

    =VLOOKUP("?*",A2:A12,1,0)

    It works when there is text in the cell - but gives an error when the cell shows a number?

    What is the fix?

    Thanks for your help!

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

    Default Re: VLOOKUP Not Showing Result ?

    Quote Originally Posted by Aitch View Post
    It's a pretty simple function - just look down the column range and display the cell that is not blank...
    If there is only one not blank then
    =SUM(A2:A12)

    Otherwise try
    =INDEX(A2:A12,MATCH(TRUE,INDEX(A2:A12<>"",0),0))
    Last edited by Peter_SSs; Aug 8th, 2019 at 09:04 AM.
    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 # key in the Reply window
    - Read: Forum Rules, Forum Use Guidelines, & FAQ

  3. #3
    Board Regular
    Join Date
    Jul 2013
    Location
    Essex, UK
    Posts
    128
    Post Thanks / Like
    Mentioned
    2 Post(s)
    Tagged
    0 Thread(s)

    Default Re: VLOOKUP Not Showing Result ?

    If you know that you have an entry, but it could be text or number, then:
    =IFERROR(VLOOKUP("?*",A2:A12,1,0),MAX(A2:A12))

    Helping you to Excel

  4. #4
    Board Regular
    Join Date
    Jan 2019
    Posts
    58
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: VLOOKUP Not Showing Result ?

    Thank you! I'd have never thought of using SUM or MAX - even though it's so obvious lol!

    Is there a specific reason why VLOOKUP doesn't play well with numbers?

  5. #5
    MrExcel MVP
    Moderator
    Peter_SSs's Avatar
    Join Date
    May 2005
    Location
    Macksville, Australia
    Posts
    40,985
    Post Thanks / Like
    Mentioned
    90 Post(s)
    Tagged
    21 Thread(s)

    Default Re: VLOOKUP Not Showing Result ?

    Quote Originally Posted by Aitch View Post
    Thank you! I'd have never thought of using SUM or MAX - even though it's so obvious lol!
    You're welcome.


    Quote Originally Posted by Aitch View Post
    Is there a specific reason why VLOOKUP doesn't play well with numbers?
    Being in quotes, your lookup value "?*" is specifically saying it is a Text value that you are looking for.
    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 # key in the Reply window
    - 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
  •