+ Reply to Thread
Results 1 to 5 of 5

VLookup function for Placing set pay amount into column by using 4 criterias

  1. #1
    Registered User
    Join Date
    11-28-2014
    Location
    United States
    MS-Off Ver
    2013
    Posts
    3

    VLookup function for Placing set pay amount into column by using 4 criterias

    I am attempting to put a set amount $ into a column that differs amounts based on type of employee "FT" or "PT". Based on Positions, "A", "B", "C", with value A set to X2, etc - X4. Null for "PT"

    I have tweaked it many ways, and have tried the IF nested as well, but the IF nested tells me that I have too many arguments. So I was going with the array and index. I'm thinking that my error is in the range_lookup, however I am out of ideas.

    The following is my formula:
    =VLOOKUP("FT",[Pay Grade],X2:X4,FALSE="NE")

    I appreciate any suggestions.

  2. #2
    Forum Expert daffodil11's Avatar
    Join Date
    07-11-2013
    Location
    Phoenixville, PA
    MS-Off Ver
    MS Office 2016
    Posts
    4,465

    Re: VLookup function for Placing set pay amount into column by using 4 criterias

    Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

    Remember to desensitize the data. Remove names, create fake numbers, etc.

    Click on GO ADVANCED and use the paperclip icon to open the upload window.

    View Pic

    Is all of your source data in a table?
    Make Mom proud: Add to my reputation if I helped out!

    Make the Moderators happy: Mark the Thread as Solved if your question was answered!

  3. #3
    Registered User
    Join Date
    11-28-2014
    Location
    United States
    MS-Off Ver
    2013
    Posts
    3

    Re: VLookup function for Placing set pay amount into column by using 4 criterias

    Here is what I am working on.
    Attached Files Attached Files

  4. #4
    Forum Expert daffodil11's Avatar
    Join Date
    07-11-2013
    Location
    Phoenixville, PA
    MS-Off Ver
    MS Office 2016
    Posts
    4,465

    Re: VLookup function for Placing set pay amount into column by using 4 criterias

    If your example D2:

    =IF(A2<>"Shirt",VLOOKUP(C2,$F$2:$G$4,2,0),"")

    and copied down
    Attached Files Attached Files

  5. #5
    Registered User
    Join Date
    11-28-2014
    Location
    United States
    MS-Off Ver
    2013
    Posts
    3

    Re: VLookup function for Placing set pay amount into column by using 4 criterias

    Thank you for your assistance.

+ 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. [SOLVED] Formula to extract top largest to smallest amount based on 3 criterias
    By aurisab in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 05-26-2013, 08:05 AM
  2. [SOLVED] In pivot match vertical row amount with the horizontal column -amount and highlight that
    By Goku in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-21-2013, 02:04 AM
  3. Replies: 12
    Last Post: 02-01-2013, 04:53 PM
  4. [SOLVED] Help - SUM column if 3 row criterias match, and a more complicated Function
    By Vehat in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-24-2012, 05:27 PM
  5. Placing a vlookup formula within a cell in VBA
    By jeskit in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-05-2011, 11:59 AM

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