+ Reply to Thread
Results 1 to 5 of 5

HELP! Search all the numbers in between +/- input number and return all results

Hybrid View

  1. #1
    Registered User
    Join Date
    06-29-2017
    Location
    Manchester, England
    MS-Off Ver
    2017
    Posts
    16

    HELP! Search all the numbers in between +/- input number and return all results

    Hello!

    Example:
    https://s24.postimg.org/d354wanfp/TEST.jpg

    I tried to do it on my own, but it's just not working. The logic is to type wanted decimal number in "user input", search for that number in column D and return all the matching values from column C. The input has to be calculated inside limit (in my case it's +/- 0,03), so the result must return all the values from column C that are inside limits.

    Example:

    Input: 8,00 +/- 0,03
    Search range: 8,03 to 7,97
    Search for all numbers in that range in column D
    And then return all values from column C in that range.

    Thank you!
    Last edited by zztop123; 06-29-2017 at 04:06 AM.

  2. #2
    Registered User
    Join Date
    06-29-2017
    Location
    Manchester, England
    MS-Off Ver
    2017
    Posts
    16

    Re: HELP! Search all the numbers in between +/- input number and return all results

    Any help would be appreciated!
    Last edited by zztop123; 06-29-2017 at 04:05 AM.

  3. #3
    Banned User!
    Join Date
    02-05-2015
    Location
    San Escobar
    MS-Off Ver
    any on PC except 365
    Posts
    12,168

    Re: HELP! Search all the numbers in between +/- input number and return all results

    If I understood well you can try: E5: =IF(AND(ROUND($D5,2)<=H$1,ROUND($D5,2)>=I$1),C5,"") and drag down, where H1 and I1 are: 8.03 and 7.97.
    but with your picture all returned values will be empty because there is no value <=8.03 in D column
    or simply use without ROUND: =IF(AND($D5<=H$1,$D5>=I$1),C5,"")
    Last edited by sandy666; 06-29-2017 at 07:13 AM.

  4. #4
    Registered User
    Join Date
    06-29-2017
    Location
    Manchester, England
    MS-Off Ver
    2017
    Posts
    16

    Re: HELP! Search all the numbers in between +/- input number and return all results

    It's working! Thank you very much!

  5. #5
    Banned User!
    Join Date
    02-05-2015
    Location
    San Escobar
    MS-Off Ver
    any on PC except 365
    Posts
    12,168

    Re: HELP! Search all the numbers in between +/- input number and return all results

    You are welcome


    If that takes care of your original question, please click on Add Reputtion (bottom left corner of the post of the person(s) who helped you) then select Thread Tools from the menu (top right corner of your thread) and mark this thread as SOLVED. Thanks.

+ 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] Code to search Excel and return results even if part of search text is present
    By Taoyuan00 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-30-2016, 09:20 AM
  2. [SOLVED] Input box to search and results in a new worksheet
    By Ashley1993 in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 12-02-2014, 09:42 AM
  3. Replies: 6
    Last Post: 08-22-2014, 08:47 AM
  4. A1=Input B1=Formula Is there anyway to return the results to overwrite A1?
    By nayers1981 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-07-2013, 11:38 PM
  5. VLOOKUP??? Input numbers to return a corresponding number from another cell
    By juntamonkey in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 03-13-2013, 05:03 PM
  6. How to search and return results
    By the deeb in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 02-09-2011, 05:57 PM
  7. Combining two macros ( user input & search/copy results)
    By newbe2009 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-12-2009, 10:19 AM

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