+ Reply to Thread
Results 1 to 15 of 15

If the condition is true then fetch the data.

Hybrid View

  1. #1
    Forum Guru (RIP) Marcol's Avatar
    Join Date
    12-23-2009
    Location
    Fife, Scotland
    MS-Off Ver
    Excel '97 & 2003/7
    Posts
    7,216

    Re: If the condition is true then fetch the data.

    @ marreco the task is to return the value from part of the lookup table based on "Courier" & "side" where the "weight" falls into a band width.

    See Post #7 (it can be simplified if the ranges are static)

  2. #2
    Valued Forum Contributor marreco's Avatar
    Join Date
    07-02-2011
    Location
    Brazil
    MS-Off Ver
    Excel 2010
    Posts
    1,862

    Re: If the condition is true then fetch the data.

    I would like you to explain in more detail for me the named ranges:
    DeliveryRates
    DeliveryBands

    I'd like to understand this brilliant idea
    Could you explain?

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

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