+ Reply to Thread
Results 1 to 6 of 6

Help with formula when I finish the result has vanished

  1. #1
    Registered User
    Join Date
    11-03-2013
    Location
    Manchester, England
    MS-Off Ver
    Excel 2010
    Posts
    4

    Post Help with formula when I finish the result has vanished

    Can anyone help me please with the attached excel sheet

    1. Explaining why the formula =IFERROR(INDEX(tblData,MATCH(C$5+$B9&ShowName,tblData[DATE & TIME]&tblData[WHO],0),3),"") is not pulling the correct data from the data entry sheet in the attached spread sheet, when I press enter the result disappears.

    2. Is it possible to have an option to see the tasks for everyone on the weekly planner on the drop down list?


    Cheers
    Attached Files Attached Files

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    Re: Help with formula when I finish the result has vanished

    Hi and welcome to the forum

    To answer your 1st question, that formula is working perfectly. The INDEX() part is returning an error, so the IFERROR part kicks in and returns ""

    Now, as to why the INDEX() is giving an error...
    1st, you are trying to add (+) 2 text strings together. What answer would you expect from "SUNDAY" + (added to) "LESSON 1"? You need to replace the + with &, so they are combined, and not added.

    2nd, the formula is trying to match combinations of data that have a space between them, you need to add that to the search crtieria. "SUNDAYLESSON 1" is not the same as "SUNDAY LESSON 1"
    So you need...
    =IFERROR(INDEX(tblData,MATCH(C$6&" "&$B7&ShowName,tblData[DAY & LESSON]&tblData[WHO],0),3),"")

    3rd, that is an ARRAY formula...confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER. You will know the array is active when you see curly braces { } appear around your formula. If you do not CTRL+SHIFT+ENTER you will get an error or a clearly incorrect answer. Press F2 on that cell and try again.

    C7=Kodesh Reading
    Last edited by FDibbins; 11-03-2013 at 06:16 PM.
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  3. #3
    Registered User
    Join Date
    11-03-2013
    Location
    Manchester, England
    MS-Off Ver
    Excel 2010
    Posts
    4

    Re: Help with formula when I finish the result has vanished

    Hi,

    Sorry for the delay in responding that works perfect now thank you for your help with this.

    Gershy

  4. #4
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    Re: Help with formula when I finish the result has vanished

    you'r welcome. If this answered your question, please take a moment to mark the thread as "solved" - it helps keep things neat and tidy lol, and consider adding the reputation to those that helped (see points 2 & 3 below my 1st post to you)

  5. #5
    Registered User
    Join Date
    10-16-2015
    Location
    Leeds
    MS-Off Ver
    Windows 7
    Posts
    1

    Re: Help with formula when I finish the result has vanished

    Hi I know this is quite and old thread, but i'm having problems with the same table and the formula doesn't seem to work for me, I've added in another column named dealer. Please can you help me -attemot2.xlsx

  6. #6
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    Re: Help with formula when I finish the result has vanished

    mishymoo62 welcome to the forum

    Unfortunately your post does not comply with Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.

    If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.

    Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.

+ 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. Wondering how to leave a cell blank until i finish the formula...
    By grrr:) in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-05-2013, 07:56 PM
  2. Sumproduct formula:start to finish
    By Scotsman89 in forum Excel General
    Replies: 5
    Last Post: 07-14-2008, 10:45 AM
  3. Find The Tuesday (Finish The Formula!)
    By SamuelT in forum Excel General
    Replies: 2
    Last Post: 11-28-2007, 10:02 AM
  4. formula to lookup & sum totals, given a start inv.# & finish inv.#
    By Learning the hard way in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-21-2006, 07:55 AM
  5. [SOLVED] Finish Formula
    By Bobby in forum Excel General
    Replies: 5
    Last Post: 07-11-2005, 10:05 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