Results 1 to 6 of 6

VLOOKUP returning an #N/A when it should return a value

Threaded View

  1. #1
    Registered User
    Join Date
    09-30-2011
    Location
    Lithuania
    MS-Off Ver
    Excel 2010
    Posts
    81

    VLOOKUP returning an #N/A when it should return a value

    Hello,

    I have attached a workbook to this post that uses this formula:

    =VLOOKUP(C5,Sheet2!$B$1:$C$99,2,0)

    in Sheet1. The value in C5 is a value produced from another formula. I've carefully checked my work, but I am still getting an error. Can anyone tell me what I am doing wrong? I encounter a similar problem from time to time, and I'm hoping this will help me understand how this formula works a little better. I have a feeling that this has to do either with cell format, or placement of the cell with the formula in relation to the data it is reading.

    Big thanks to anyone who can help at all with this!
    Attached Files Attached Files
    Last edited by Nate Westcott; 12-10-2015 at 05:08 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Vlookup to return multiple rows in return
    By Excelhelpss in forum Excel General
    Replies: 1
    Last Post: 06-18-2015, 09:59 AM
  2. Nested IF Returning False - Need to Return True for Three Scenarios
    By rhelmer in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 05-18-2015, 05:50 PM
  3. Using vLookup based on results from a vLookup & returning an undetermined list
    By NormalityBan in forum Excel Formulas & Functions
    Replies: 15
    Last Post: 08-14-2014, 05:02 AM
  4. [SOLVED] Return carriage not returning to row under original cell
    By HH61 in forum Excel General
    Replies: 4
    Last Post: 05-07-2014, 02:08 PM
  5. [SOLVED] Formula to always return cell below what a vlookup would return
    By KCHEXCEL in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 08-28-2013, 12:57 AM
  6. [SOLVED] Why is this formula returning a FALSE result? It should return the value in B13
    By golfpromal in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 10-20-2012, 05:22 PM
  7. Returning a $ value if a checkbox return true
    By dellie in forum Excel General
    Replies: 3
    Last Post: 02-06-2009, 02:53 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