+ Reply to Thread
Results 1 to 4 of 4

VLOOKUP formula problem

  1. #1
    Forum Contributor
    Join Date
    02-05-2014
    Location
    Bay Area
    MS-Off Ver
    Excel 2010
    Posts
    126

    VLOOKUP formula problem

    Dear people who are smarter than me,

    I have a formula with VLOOKUP formulas that is not working, and I can’t figure out where my problem is. After a crazy amount of time trying to figure it out, I figured I’d ask people who know more than me.

    I attached a sample file with my “broken” formula. I highlighted the cells in question. Note that there are two sheets in the workbook.

    My challenge is the following:

    I need to calculate the headcount of a particular position, based on the appropriate combination a) the previous month’s headcount, and b) the current production, divided by the “staff metric”; or I insert “0” if the previous two criteria are false.

    In the attached workbook, take the Administrative Assistant position, as an example (row 8 on the Results sheet). I cannot figure out why I’m getting the “#N/A” message and not a zero for January 2014. In fact, for the highlighted cells I should get the following results. However, you'll see that my results are different than my expectation.
    D6 = 1
    D7 = 0
    D8 = 0
    D9 = 0
    D10 = 0
    D11 = 1

    Thank you for any help you can provide.
    Attached Files Attached Files

  2. #2
    Valued Forum Contributor
    Join Date
    04-22-2014
    Location
    Auckland, New Zealand
    MS-Off Ver
    Excel 2016 (work) and 2013 (home)
    Posts
    1,164

    Re: VLOOKUP formula problem

    Add a ,0 or ,FALSE to the end of your vlookup's. It gets the last part of your equation working at least (get's rid of the #N/A error).

  3. #3
    Valued Forum Contributor
    Join Date
    04-22-2014
    Location
    Auckland, New Zealand
    MS-Off Ver
    Excel 2016 (work) and 2013 (home)
    Posts
    1,164

    Re: VLOOKUP formula problem

    Have modified your formula for D6 to:
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    You need to replace what I have entered in quote marks and square brackets.

  4. #4
    Forum Contributor
    Join Date
    02-05-2014
    Location
    Bay Area
    MS-Off Ver
    Excel 2010
    Posts
    126

    Re: VLOOKUP formula problem

    I can't believe it was that simple of a fix (albeit "simple" is subjective). That solution works. Thank you very much, gak67!

+ 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. Vlookup formula problem!!!
    By ciapul12 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 10-25-2013, 07:09 AM
  2. [SOLVED] VLookup formula problem
    By m_789 in forum Excel General
    Replies: 7
    Last Post: 06-08-2012, 04:20 PM
  3. vlookup formula problem
    By StiefBijer in forum Excel General
    Replies: 1
    Last Post: 09-29-2011, 01:29 PM
  4. Problem with Vlookup formula
    By monkey2003 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 05-28-2008, 06:58 PM
  5. Vlookup/If? Formula problem?
    By Langoose in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 04-27-2006, 01:10 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