+ Reply to Thread
Results 1 to 2 of 2

To find a number according to the table (not using IF)

  1. #1
    Registered User
    Join Date
    08-04-2017
    Location
    Germany
    MS-Off Ver
    10
    Posts
    9

    To find a number according to the table (not using IF)

    Dear all,

    I need your Support. Not to describe too Long, I am attaching an Excel file... I Need a formula different than IF...I tried with IF, but I want to check whether there is other formula to use in this case...

    Thanks
    Attached Files Attached Files
    Last edited by sarstep1; 08-28-2017 at 10:36 AM. Reason: Was not relevant to general rules

  2. #2
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,987

    Re: Difficulties with a formula

    Please read and adhere to these simple rules!

    1. Use concise, accurate thread titles. Your post title should describe your problem, not your anticipated solution. Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.

    To change the title of the thread, click EDIT on the original post, then click the Go Advanced button, then change the title. If two or more days have passed, the EDIT button will not appear, and you need to ask a moderator to change the title.


    After you have done that, please also add the expected results (manualy) in your file.
    Notice my main language is not English.

    I appreciate it, if you reply on my solution.

    If you are satisfied with the solution, please mark the question solved.

    You can add reputation by clicking on the star * add reputation.

+ 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. [SOLVED] Difficulties with repeating dates and numbers when extending column with formula
    By AtriosM3 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-16-2013, 01:36 PM
  2. Difficulties adapting an intercept formula
    By ndw123 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 03-16-2013, 05:01 PM
  3. Difficulties with sumproduct/choose formula
    By amartino44 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-22-2013, 06:41 PM
  4. Having difficulties with Networkdays formula in my macro
    By dwhite30518 in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 07-23-2012, 04:13 PM
  5. Replies: 1
    Last Post: 04-06-2012, 04:14 AM
  6. Difficulties
    By Guest001 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-05-2008, 07:39 AM
  7. Difficulties with a large formula
    By SweetSin80 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-13-2006, 04:45 PM
  8. RE: Difficulties with a large formula
    By Jim Thomlinson in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-13-2006, 04:40 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