+ Reply to Thread
Results 1 to 4 of 4

Vlookup Help

  1. #1
    Registered User
    Join Date
    08-04-2011
    Location
    nashville
    MS-Off Ver
    Excel 2003
    Posts
    32

    Vlookup Help

    On the attached for sheet2 I am not sure what is wrong with my formula in column Q I am getting N/A. Please help!
    Attached Files Attached Files

  2. #2
    Registered User
    Join Date
    05-31-2012
    Location
    United States, FL
    MS-Off Ver
    Excel 2010
    Posts
    11

    Re: Vlookup Help

    Quote Originally Posted by jBailey031285 View Post
    On the attached for sheet2 I am not sure what is wrong with my formula in column Q I am getting N/A. Please help!
    Am I missing Something? When I look at the Formula:

    =VLOOKUP(A8,'Budget With Drivers'!A:C,3,0)

    This means its looking up the director fees from "Budget with Drivers" sheet.

    When I go to that shee I dont see "815161-0000 Director Fees" in Column A at all.

    If I do a Search for "815161-0000 Director Fees" its not found in the Sheet at all.

  3. #3
    Forum Contributor
    Join Date
    06-09-2011
    Location
    Germany
    MS-Off Ver
    Excel 2016
    Posts
    194

    Re: Vlookup Help

    Hi JBailey,

    simple cause: the values in sheet2 column A simply do not exist in column A of the buget with drivers table

    Regards

    Theo
    Remember To Do the Following....
    1. Upload sample files
    2. Thank those who have helped you by clicking the Star below the post.
    3. Please mark your post [SOLVED] if it has been answered satisfactorily.

  4. #4
    Forum Expert Cutter's Avatar
    Join Date
    05-24-2004
    Location
    Ontario,Canada
    MS-Off Ver
    Excel 2010
    Posts
    6,451

    Re: Vlookup Help

    Your VLOOKUP()s are looking for matches in col A of the other sheet but matches are not being found.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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