+ Reply to Thread
Results 1 to 5 of 5

I have a formula that when split they both work, when put together only half reads correct

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

    I have a formula that when split they both work, when put together only half reads correct

    So,

    2 seperate formulas that i would like to read into the same cell. I have got both working independently but cannot figure out why they will not work together...

    =IF(C7="WST",IF(I7="","",VLOOKUP(J7,Data!B:H,7,FALSE))) This works...

    =IF(C7="Maxims",INDEX(Data!$AA$6:$AJ$31,M7,VLOOKUP(I7,Data!A:I,9,0)),"") This works...

    =IF(C7="WST",IF(I7="","",VLOOKUP(J7,Data!B:H,7,IF(C7="Maxims",INDEX(Data!$AA$6:$AJ$31,M7,VLOOKUP(I7,Data!A:I,9))))),"") This works for "WST" but not reading "MAXIMS".


    Please HELP!!!!!!!!!

  2. #2
    Forum Expert shukla.ankur281190's Avatar
    Join Date
    05-17-2014
    Location
    Lucknow, India
    MS-Off Ver
    Office 365
    Posts
    3,935

    Re: I have a formula that when split they both work, when put together only half reads cor

    May be try

    Formula: copy to clipboard
    Please Login or Register  to view this content.
    If I helped, Don't forget to add reputation (click on the little star ★ at bottom of this post)
    Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)

  3. #3
    Forum Expert rorya's Avatar
    Join Date
    08-13-2008
    Location
    East Sussex, UK
    MS-Off Ver
    365 Ent Monthly Channel / Insiders Beta
    Posts
    8,908

    Re: I have a formula that when split they both work, when put together only half reads cor

    Perhaps:

    =IF(C7="WST",IF(I7="","",VLOOKUP(J7,Data!B:H,7,FALSE)),IF(C7="Maxims",INDEX(Data!$AA$6:$AJ$31,M7,VLOOKUP(I7,Data!A:I,9,0)),""))
    Rory

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

    Re: I have a formula that when split they both work, when put together only half reads cor

    You are a superhero!

    Thankyou very much for your help!

  5. #5
    Forum Expert rorya's Avatar
    Join Date
    08-13-2008
    Location
    East Sussex, UK
    MS-Off Ver
    365 Ent Monthly Channel / Insiders Beta
    Posts
    8,908

    Re: I have a formula that when split they both work, when put together only half reads cor

    Glad to help.

+ 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: 5
    Last Post: 04-17-2017, 09:36 PM
  2. Cant work out the correct formula to use
    By jwardlow84 in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 04-27-2015, 01:06 PM
  3. 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
  4. [SOLVED] Split a Cell Reference in Half
    By nathanB in forum Excel General
    Replies: 3
    Last Post: 01-08-2013, 08:05 AM
  5. Is there a way to split a cell in half?
    By Millenium in forum Excel General
    Replies: 2
    Last Post: 10-02-2011, 07:14 PM
  6. Split a column in half?
    By Jeroen1000 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-23-2009, 03:01 AM
  7. placing a half line within split columns
    By m3site in forum Excel General
    Replies: 3
    Last Post: 08-27-2008, 05:13 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