+ Reply to Thread
Results 1 to 8 of 8

Could you tell me why the second half on this formula is not working?

  1. #1
    Registered User
    Join Date
    02-04-2019
    Location
    Essex
    MS-Off Ver
    365
    Posts
    63

    Could you tell me why the second half on this formula is not working?

    So the "WST" formula is working perfectly but the "MAXIMS" just seems to keep coming back with "FALSE". If i split the two formulas they both work independently. Any help would be much appreciated!

    =IF(C8="WST",IF(I8="","",VLOOKUP(J8,Data!B:H,7,IF(C8="MAXIMS",IF(I8="","",VLOOKUP(J8,Data!B:I,8,FALSE))))))

    Thanks!!

  2. #2
    Forum Guru samba_ravi's Avatar
    Join Date
    07-26-2011
    Location
    Hyderabad, India
    MS-Off Ver
    Excel 2021
    Posts
    8,904

    Re: Could you tell me why the second half on this formula is not working?

    Try
    =if(c8="wst",if(i8="","",vlookup(j8,data!b:h,7,0)),if(c8="maxims",if(i8="","",vlookup(j8,data!b:i,8,false))))
    Samba

    Say thanks to those who have helped you by clicking Add Reputation star.

  3. #3
    Registered User
    Join Date
    02-04-2019
    Location
    Essex
    MS-Off Ver
    365
    Posts
    63

    Re: Could you tell me why the second half on this formula is not working?

    HI,

    Unfortunately this has done the same as earlier and has come out with the same answer as the "first half". The answer to the first half is in tab DATA column H and the second half should be from column I, if this helps at all?

  4. #4
    Forum Guru Bo_Ry's Avatar
    Join Date
    09-10-2018
    Location
    Thailand
    MS-Off Ver
    MS 365
    Posts
    7,211

    Re: Could you tell me why the second half on this formula is not working?

    How about

    =IF(C8="","",VLOOKUP(J8,Data!B:I,7+(C8<>"wst"),0))

  5. #5
    Registered User
    Join Date
    02-04-2019
    Location
    Essex
    MS-Off Ver
    365
    Posts
    63

    Re: Could you tell me why the second half on this formula is not working?

    The exact same issue again, reading the answer for "WST" with either option.

  6. #6
    Forum Guru Bo_Ry's Avatar
    Join Date
    09-10-2018
    Location
    Thailand
    MS-Off Ver
    MS 365
    Posts
    7,211

    Re: Could you tell me why the second half on this formula is not working?

    Please help to upload your file with mock up the results manually, Go Advanced > Manage Attachments

    Make sure that all confidential data is removed or replaced with dummy data first

  7. #7
    Registered User
    Join Date
    02-04-2019
    Location
    Essex
    MS-Off Ver
    365
    Posts
    63

    Re: Could you tell me why the second half on this formula is not working?

    I Have just tried to do this, and deleted most of the content but unfortunately the file size is way to big :/

  8. #8
    Forum Guru Bo_Ry's Avatar
    Join Date
    09-10-2018
    Location
    Thailand
    MS-Off Ver
    MS 365
    Posts
    7,211

    Re: Could you tell me why the second half on this formula is not working?

    We just need sample 10-20 rows is enough.

+ 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. Count Employees Working in Half Hour Intervals
    By shanewfm in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 01-24-2015, 01:12 PM
  2. Formula to calculate half wins and half losses
    By chilli76 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 11-27-2014, 07:33 AM
  3. Formula half working. IF( Countifs)
    By Unnefable in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 12-01-2013, 12:11 PM
  4. vba copy paste only half working
    By Mummraah in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 10-31-2012, 07:29 AM
  5. [SOLVED] Formula to calculate if employee is working on each half hour
    By holowugz in forum Excel General
    Replies: 10
    Last Post: 07-16-2012, 08:29 PM
  6. time and a half working a holiday
    By whitelighter in forum Excel General
    Replies: 5
    Last Post: 09-21-2010, 11:26 AM
  7. Vlookup only working half way down spreadsheet?
    By thehotexceller in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-21-2009, 06:23 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