Results 1 to 8 of 8

Grid Index/V-lookup Help

Threaded View

  1. #1
    Registered User
    Join Date
    12-18-2018
    Location
    Minnesota, USA
    MS-Off Ver
    2016
    Posts
    7

    Question Grid Index/V-lookup Help

    Hi,

    I am hoping someone can help me with a vlookup/index formula (or a different formula if someone knows of something that works better for the following example)...

    I'm creating a tool for modeling and have a grid that I'm referencing for a master modeling tab. The grid contains multiple districts. Each district will have different levels based on the office locations employee size. The estimated budget for each office location can be found by the number of employees in the office.

    I then have another tab where the modeling for all of the office locations takes place. I need a formula that finds the budget for each office location based on their employee size. The problem with Indexing or Vlookups is that it's asking for specific column numbers. I don't have specific column numbers to reference. I'm trying to find the district that the office location is in and the column reference will be the # of employees that the modeling tab matches to. (for example, the office location is assigned to a certain district - that district has its own budget levels based on employee size: 1, 50, 100, 150, 200, 250. If the office location has 140 employees, it would match to the 100 employees level - not 150 as it has not hit that level of employees yet).

    Sorry if this is really confusing.. i'm at a loss with what to do. I have attached an example spreadsheet with everything all in on tab. The inputs are in the table to the right and the "modeling" is the table to the left. The yellow cells under "Budget" is what i am looking for.
    Attached Files Attached Files
    Last edited by egren; 01-09-2020 at 11:52 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Formula for grid lookup
    By jarheadmartian in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 11-22-2016, 06:07 PM
  2. need help using index/match to search grid
    By tsiguy96 in forum Excel General
    Replies: 2
    Last Post: 12-11-2013, 08:33 AM
  3. Using Index and Match to lookup a value in a grid
    By jcranst in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 11-05-2012, 01:01 PM
  4. Price Grid [index/lookup/match]
    By casey63 in forum Excel General
    Replies: 5
    Last Post: 04-01-2012, 05:26 PM
  5. Price grid (index/lookup/match)
    By casey63 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-01-2012, 05:23 PM
  6. Price Grid [Index/Lookup/Match]
    By jaredg in forum Excel General
    Replies: 8
    Last Post: 01-25-2012, 01:27 PM
  7. Staffing Grid - Index Match Help
    By Justinmih in forum Excel General
    Replies: 0
    Last Post: 06-21-2010, 07:27 PM

Tags for this Thread

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