Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Page 2 of 2 FirstFirst 12
Results 11 to 15 of 15

Thread: Need to pick numbers in a range of numbers

  1. #11
    MrExcel MVP Aladin Akyurek's Avatar
    Join Date
    Feb 2002
    Location
    The Hague, NL
    Posts
    84,035
    Post Thanks / Like
    Mentioned
    37 Post(s)
    Tagged
    7 Thread(s)

    Default

    On 2002-05-08 10:40, Wing-it wrote:
    Please don't give up on me know!!!!
    I'm not sure I understand what you want at all. Maybe you should produce, given a pair (T3 and U3 values), the expected results for 5 rows of sample that you posted along with the reasoning how you arrived at them.


  2. #12
    New Member
    Join Date
    May 2002
    Posts
    8
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    well, lets start over,,,,
    in cell T3 and U3 are the numbers I enter in, t3=500 or 520 or 490 or factors of 10 +/-, U3= is the other end of the range, +/- 10. these number change pending on what range im looking for.

    the data that the range is looking in is
    526 454 the result
    510 477 "
    500 471 "
    507 473 "
    500 495 "
    530 500 the result.

    now I don't know how easy this is but pending on what I enter in t3 and u3 the formula should check between the two columns to find a match or close match to the number spread I entered in t3 & u3, or should i say if i entered 500 in t3 and 490 in u3 the result should indicate which row in the data fell in between the assigined numbers i entered in t3 & u3, nothing over or under but in between or exact.

    thanks

  3. #13
    MrExcel MVP
    Join Date
    Mar 2002
    Location
    Michigan USA
    Posts
    11,454
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    On 2002-05-08 10:40, Wing-it wrote:
    Please don't give up on me know!!!!
    Hi Wing-it:
    Looks like you are having difficulty describing what you are trying to accomplish. Please state clearly:
    1. in which cells are the lookup values
    2. in which cells is your list data
    3. which number are you looking up for in what range of cells
    I am sure if you can clearly define your problem, the solution should be not that hard to find.
    If you want to email me your worksheet with a clear description of what you are trying to accomplish, I will be glad to look at and respond.

    Good Luck!
    Regards!

    Yogi Anand, D.Eng, P.E.
    Energy Efficient Building Network LLC
    www.energyefficientbuild.com

  4. #14
    New Member
    Join Date
    May 2002
    Posts
    8
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    thanks I sending now

  5. #15
    MrExcel MVP
    Join Date
    Mar 2002
    Location
    Michigan USA
    Posts
    11,454
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    On 2002-05-08 11:16, Wing-it wrote:
    thanks I sending now
    Hi Scott:
    As discussed with you, there was need to add another parameter for tolerance up and down to work with your search values. I have emailed the worksheet back to you.
    Please post back if it works for you ... otherwise explain a little further and let us take it from there!
    Regards!

    Yogi Anand, D.Eng, P.E.
    Energy Efficient Building Network LLC
    www.energyefficientbuild.com

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •