+ Reply to Thread
Results 1 to 3 of 3

Display Cell within VLookup range that excel thinks matches the VLookup Value

  1. #1
    Registered User
    Join Date
    02-10-2012
    Location
    desk, office
    MS-Off Ver
    Excel 2010
    Posts
    2

    Display Cell within VLookup range that excel thinks matches the VLookup Value

    just wondering, is there a formula that will display the cell that excel thinks matches the lookup criteria?

    specific case:

    my vlookup is for a column of data, and one of the cells within the lookup column is actually a blank cell. Within the lookup range, there are no blank cells, but I am still getting a result.

    My suspcision is that it is returning based on one of the cells within the range being the number zero (0), so therefore (empty cell) = 'zero' in excel's eyes, but I would like a formula to confirm this suspicion 100%.

  2. #2
    Forum Expert BadlySpelledBuoy's Avatar
    Join Date
    06-14-2013
    Location
    East Sussex, UK
    MS-Off Ver
    365
    Posts
    6,537

    Re: Display Cell within VLookup range that excel thinks matches the VLookup Value

    Can you show up what your specific VLOOKUP formula is?

  3. #3
    Registered User
    Join Date
    02-10-2012
    Location
    desk, office
    MS-Off Ver
    Excel 2010
    Posts
    2

    Re: Display Cell within VLookup range that excel thinks matches the VLookup Value

    =VLOOKUP(B4952,'File 1'!$B$2:$G$238,6,0)

    the lookup value is a blank cell (B4952), the lookup range ($B$2:$G$238) has one zero (0) cell in Column 'B', where 6 to the left of it is the result that was returned. The result appears within other instances within the lookup range, so I cannot be 100% sure that the zero cell is being intepreted as matching the Blank cell lookup value.

+ 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. If Cell Text Matches Any Text From Range, Then Apply VLOOKUP?
    By eliot1171 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 04-12-2013, 09:41 PM
  2. [SOLVED] VLookup if cell contains (rather than matches) a string.
    By Alex H in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-19-2013, 01:29 PM
  3. [SOLVED] Vlookup or If/Then to return a substitute cell for a cell that matches itself in a range
    By Shadefalcon in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 11-13-2012, 06:02 PM
  4. Replies: 6
    Last Post: 09-04-2012, 10:35 AM
  5. VLOOKUP - Return sum of all matches in Range?
    By Wiggz in forum Excel General
    Replies: 3
    Last Post: 01-25-2007, 06:42 AM

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