+ Reply to Thread
Results 1 to 5 of 5

Nested VLookup in an IF Function

  1. #1
    Registered User
    Join Date
    03-06-2014
    Location
    United Kingdom
    MS-Off Ver
    Excel 2010
    Posts
    34

    Nested VLookup in an IF Function

    At the moment I'm trying to create a timesheet which will pull up an alert if a candidate has worked more than 45 hours and also hasn't signed an opt out. It's spread over a couple of worksheets and at present I can't seem to get the functions to work together. The formula I have at the moment works out as:

    =IF('Data Entry'!E4>=45,VLOOKUP(B8,Source!E:H,4,"NO"),"This candidate has exceeded the Working Time Regulations and has not opted out, please contact The Academy."," "))

    I have attached an example of how its set up
    Attached Files Attached Files

  2. #2
    Forum Expert Sam Capricci's Avatar
    Join Date
    06-14-2012
    Location
    Palm Harbor, Florida
    MS-Off Ver
    16.95 for Mac MS 365
    Posts
    8,682

    Re: Nested VLookup in an IF Function

    where do you want that formula entered? (which sheet, which cells?)
    Make contributors happy, click on the "* Add Reputation" as a way to say thank you.
    Sam Capricci

  3. #3
    Registered User
    Join Date
    03-06-2014
    Location
    United Kingdom
    MS-Off Ver
    Excel 2010
    Posts
    34

    Re: Nested VLookup in an IF Function

    It will be going onto Sheet "Manager Entry" in B16 (in place of the coding currently in there)

  4. #4
    Forum Expert Sam Capricci's Avatar
    Join Date
    06-14-2012
    Location
    Palm Harbor, Florida
    MS-Off Ver
    16.95 for Mac MS 365
    Posts
    8,682

    Re: Nested VLookup in an IF Function

    without recreating your whole chart seperately, I can't tell if this formula works but I don't get any errors. The cell (data entry E4) I cannot enter a value into to check it against. So see if this works for you in B16...
    =IF(ISNA(VLOOKUP(B8,Source!E:H,4,FALSE)),'Data Entry'!E4>=45,"Total hours exceed the Working Time Regulations. Please ensure that this casual has opted out by contacting The ,""")

  5. #5
    Registered User
    Join Date
    03-06-2014
    Location
    United Kingdom
    MS-Off Ver
    Excel 2010
    Posts
    34

    Re: Nested VLookup in an IF Function

    Thanks, but it doesn't quite work. The end of the code you've posted isn't quite right, so when I corrected it it told me that I had too many arguments in the function.

+ 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. Nested Vlookup and IF function????
    By Simon Lloyd in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 05-14-2006, 05:25 PM
  2. Nested If with VLOOKUP's and AND function
    By GBO in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 11:05 AM
  3. [SOLVED] Nested If with VLOOKUP's and AND function
    By Biff in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-06-2005, 09:05 AM
  4. Nested If with VLOOKUP's and AND function
    By GBO in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 02:05 AM
  5. Nested If with VLOOKUP's and AND function
    By GBO in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 01:05 AM

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