+ Reply to Thread
Results 1 to 3 of 3

Vlookup returning 0 and not text ( Email Address) in cell

  1. #1
    Registered User
    Join Date
    05-18-2017
    Location
    Canberra
    MS-Off Ver
    2016-365
    Posts
    22

    Vlookup returning 0 and not text ( Email Address) in cell

    Hi All

    i am have a data validation list in H4. in J4 i am trying to get a email address from another worksheet.using =VLOOKUP($H4,'Naming Sheet Folio'!$B2:$F62,5,TRUE).
    the email address are in column 5. the names in H4 come from another worksheet.
    any ideas why it returns a 0 and not the email address.

    any help
    Thank you
    kind regards
    Mark
    Last edited by MarkGannon; 12-03-2017 at 07:52 AM.

  2. #2
    Forum Expert Sam Capricci's Avatar
    Join Date
    06-14-2012
    Location
    Palm Harbor, Florida
    MS-Off Ver
    16.84 for Mac MS 365
    Posts
    8,496

    Re: Vlookup returning 0 and not text ( Email Address) in cell

    A zero usually means it is finding the value in H4 but there is no value in the cell in column F across from it. To get much more help you may have to upload a sample sheet.

    EDIT: is it doing this for all values it finds?
    Make contributors happy, click on the "* Add Reputation" as a way to say thank you.
    Sam Capricci

  3. #3
    Registered User
    Join Date
    05-18-2017
    Location
    Canberra
    MS-Off Ver
    2016-365
    Posts
    22

    Re: Vlookup returning 0 and not text ( Email Address) in cell

    Kid you are the best and nicest
    i relooked at it and changed it to this

    =VLOOKUP($H4,'Naming Sheet Folio'!$B2:$F62,4,FALSE)

    thank you so much

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] VBA to send email using data from the EXCEL including email address, subject and body text
    By ec4excel in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-18-2016, 11:07 AM
  2. Email range of text to specific email address
    By chaysp81 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-10-2016, 02:57 AM
  3. Returning a cell address from a VLOOKUP function
    By manning457 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 06-23-2015, 02:41 PM
  4. [SOLVED] Combining text in cells A,B,C,D and E into cell F to make an email address.
    By MECO in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 03-10-2014, 04:05 PM
  5. [SOLVED] Removing all text except email address from one cell
    By Steve_123 in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 01-09-2014, 07:07 AM
  6. Replies: 5
    Last Post: 08-24-2012, 09:19 AM
  7. Replies: 1
    Last Post: 03-08-2012, 01:57 PM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1