+ Reply to Thread
Results 1 to 5 of 5

Tricky Problem

  1. #1
    Registered User
    Join Date
    United States
    MS-Off Ver
    Excel 2007

    Tricky Problem

    I need to use a lookup formula to have Cell X = .63 by having the formula look up the shipping rate for the extended Cost (12.50) then comparing it to the Extended $ in the lower table. Picture attached for better visual.

    Extended Shipping
    $12.50 Cell X

    Extended $ Rate
    0 1%
    10 5%
    100 10%
    Attached Images Attached Images

  2. #2
    Valued Forum Contributor Saarang84's Avatar
    Join Date
    Chennai, India
    MS-Off Ver
    XL 2003 to 2010

    Re: Tricky Problem


    Welcome to the Forum.

    It would be useful if you could upload sample data (insensitive) in a workbook, instead of posting screenshots. People who look into your thread won't replicate the data from images.
    If my assistance has helped, there is a reputation icon * on the left hand corner below the post - you can show your appreciation to the user who has helped in resolving your requirement.

    If your requirement has been solved please mark your thread as Solved.
    In the menu bar above the very first post, select Thread Tools, then select "Mark this thread as Solved".

    Kindly use [FORMULA] or [CODE] tags when posting your code.


  3. #3
    Valued Forum Contributor
    Join Date
    Auckland, New Zealand
    MS-Off Ver
    Excel 2016 (work) and 2013 (home)

    Re: Tricky Problem

    Assuming your data in the picture starts from A1
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    Last edited by gak67; 06-05-2014 at 10:54 PM.
    Please add reputation by clicking on the * if I have helped.
    Please mark the thread SOLVED if your issue has been resolved.
    Thanks, Glenn.

  4. #4
    Valued Forum Contributor Saarang84's Avatar
    Join Date
    Chennai, India
    MS-Off Ver
    XL 2003 to 2010

    Re: Tricky Problem

    Is this what you need?
    Attached Files Attached Files

  5. #5
    Administrator FDibbins's Avatar
    Join Date
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16

    Re: Tricky Problem

    Welcome to the forum

    Please take a moment to read the forum rules and then amend your thread title to something descriptive of your problem (think google search terms?). Once you have done this please send me a PM and I will remove this request. (Also, include a link to your thread - copy from the address bar)

    To change a Title on your post, click EDIT POST then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.
    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


+ 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. Very Tricky problem in EXCEL
    By sramidi in forum Excel General
    Replies: 1
    Last Post: 01-23-2012, 05:31 AM
  2. Help required for a tricky problem(s)
    By zybatu01 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 11-03-2008, 12:19 PM
  3. Tricky Extraction Problem
    By Spreadsheet in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 11-11-2006, 03:22 AM
  4. Tricky Problem
    By pytelium in forum Excel General
    Replies: 6
    Last Post: 08-13-2005, 05:44 PM
  5. borders - tricky problem
    By joule in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-21-2005, 03:57 PM


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