Results 1 to 5 of 5

Nested VLookup in an IF Function

Threaded View

distortthecode Nested VLookup in an IF... 04-25-2014, 06:41 AM
Sam Capricci Re: Nested VLookup in an IF... 04-25-2014, 06:55 AM
distortthecode Re: Nested VLookup in an IF... 04-25-2014, 06:57 AM
Sam Capricci Re: Nested VLookup in an IF... 04-25-2014, 07:10 AM
distortthecode Re: Nested VLookup in an IF... 04-25-2014, 08:16 AM
  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

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