+ Reply to Thread
Results 1 to 3 of 3

[VLOOKUP] Help with making automatic system

  1. #1
    Registered User
    Join Date
    04-03-2016
    Location
    Australia
    MS-Off Ver
    2016
    Posts
    6

    Question [VLOOKUP] Help with making automatic system

    Hello everyone,

    So I'm having trouble with making my vlookup formula work.


    So basically I'm trying to make the number of staff automatically change when we have hit a certain amount of animals at our shelter. I have already made a data table, but I'm having trouble making it all work.

    Data table is on Data tab "Workers per animal" & Staff numbers is in the staff tab. As you can see everything is automatic (Animals).

    If someone could help me that would be greatly appreciated! Thanks
    Last edited by ForgottenName; 04-03-2016 at 10:43 AM.

  2. #2
    Forum Expert José Augusto's Avatar
    Join Date
    10-29-2014
    Location
    Portugal
    MS-Off Ver
    2013-2016
    Posts
    3,329

    Re: [VLOOKUP] Help with making automatic system

    Hi
    Use the helper cell F1 (or other) with the formula
    Formula: copy to clipboard
    Please Login or Register  to view this content.

    and in C4 (copy down)
    Formula: copy to clipboard
    Please Login or Register  to view this content.

    For clarification see the file Book3 (1).xlsx

  3. #3
    Registered User
    Join Date
    04-03-2016
    Location
    Australia
    MS-Off Ver
    2016
    Posts
    6

    Re: [VLOOKUP] Help with making automatic system

    Thanks for the help, that summed things up

+ 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. Replies: 3
    Last Post: 12-04-2014, 01:27 PM
  2. Replies: 0
    Last Post: 12-26-2013, 01:12 PM
  3. Display Cell within VLookup range that excel thinks matches the VLookup Value
    By headachexcelperson in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-04-2013, 04:56 PM
  4. [SOLVED] Vlookup is not working and giving =vlookup(B2,$T$2:$U$135,2,false) this kind of values.
    By yogeshsharma1981 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-09-2013, 04:08 PM
  5. vlookup? match? index? MULTIPLE criteria for vlookup search problem....
    By aborg88 in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 02-11-2013, 09:56 AM
  6. Replies: 5
    Last Post: 07-29-2009, 07:53 AM
  7. vlookup function-Can vlookup command find the data from the 5 sheets.
    By Rishab shah in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-05-2005, 11:05 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