Closed Thread
Results 1 to 4 of 4

Complex VLOOK and/or Index formula question. Expert advice needed

  1. #1
    Registered User
    Join Date
    10-19-2012
    Location
    United States
    MS-Off Ver
    Excel 2010
    Posts
    18

    Complex VLOOK and/or Index formula question. Expert advice needed

    Hi - I am in need of help. I am trying to create a workbook that will allow me to report the hours, cost, and revenue for a budget that I manage. Instead of manually typing this information in for 100 + employees each month, I would like to have a formula that will allow me to download the current month data right into excel and then have the formula populate all the data for me.

    I have attached the workbook that I am trying to create and posted some information below on what is specific to my needs. Can someone please help me in creating a VLOOK and/or an Index formula that will allow this file to work? I am looking for the easiest way possible to do this, so if there is another way to create this formula, I am open to that as well.

    - I will have multiple budgets that I need to manage, they will be separated by the Job No that is on each row of the Hours, Cost, and Revenue tables within the Table tab
    - Within the Job No there will be multiple employees that I need to pull in information from the Data tab. I am only using one for now to make this formula as simple as possible.
    - Each employees unique characteristic is their employee ID No. I would like to have the formula written with that being the main lookup.
    - When I update the actuals each month, it is very common for the employee to have multiple rows of data for the current month. I need the formula to be able to look up all of the rows of data within that current month and update the actuals based on the total for that month.
    -I will have three different sets of data that I need to pull for each employee, they are Hours, Cost, & Revenue
    -I can not manipulate the Data tab in anyway. The way that the numbers are showing currently in the workbook are how they will appear in the download from the database.

    If anyone can please help me get this started, I would be very appreciative!!

    Excel Forum Sample 1.xlsx

  2. #2
    Forum Moderator Fotis1991's Avatar
    Join Date
    10-11-2011
    Location
    Athens(The homeland of the Democracy!). Greece
    MS-Off Ver
    Excel 1997!&2003 & 2007&2010
    Posts
    13,744

    Re: Complex VLOOK and/or Index formula question. Expert advice needed

    No need to post twice for the same issue.

    http://www.excelforum.com/excel-form...ce-needed.html
    Regards

    Fotis.

    -This is my Greek whisper to Europe.

    --Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.

    Advanced Excel Techniques: http://excelxor.com/

    --KISS(Keep it simple Stupid)

    --Bring them back.

    ---See about Acropolis of Athens.

    --Visit Greece.

  3. #3
    Registered User
    Join Date
    10-19-2012
    Location
    United States
    MS-Off Ver
    Excel 2010
    Posts
    18

    Re: Complex VLOOK and/or Index formula question. Expert advice needed

    Quote Originally Posted by Fotis1991 View Post
    No need to post twice for the same issue.

    http://www.excelforum.com/excel-form...ce-needed.html
    It was a mistake.

  4. #4
    Forum Moderator jeffreybrown's Avatar
    Join Date
    02-19-2009
    Location
    Cibolo, TX
    MS-Off Ver
    Excel 2016
    Posts
    10,054

    Re: Complex VLOOK and/or Index formula question. Expert advice needed

    Welcome to the Forum, unfortunately:

    This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

    Thread Closed.
    HTH
    Regards, Jeff

Closed 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