+ Reply to Thread
Results 1 to 5 of 5

Find number equal to or grater then (not less then)

  1. #1
    Forum Contributor
    Join Date
    04-27-2014
    Location
    england
    MS-Off Ver
    excel 2003,2016 and google sheets
    Posts
    112

    Find number equal to or grater then (not less then)

    Hey all I'm using google sheets, just wondering if anyone could help as I don't think it can be done with vlookup, what I want to do is when I type a number in cells a2-a5 on sheet1, I need it to search sheet2 coloum a for the number equal to or nearest but grater then to the number, then add the info for that row to sheet1, I have made a example and filled in the needed results manually. Thanks

    Here is a example.

    https://docs.google.com/spreadsheets...mOCC8dJRKE4NtI
    Last edited by Ditch1983; 09-03-2017 at 03:11 PM.

  2. #2
    Forum Expert etaf's Avatar
    Join Date
    10-22-2004
    Location
    Surrey, UK
    Posts
    4,889

    Re: Find number equal to or grater then (not less then)

    can you sort sheet 2
    =INDEX(Sheet2!A:A,MATCH(Sheet1!A9,Sheet2!A:A,-1))
    Attached Files Attached Files
    Wayne

    if my assistance has helped, and only if you wish to , there is a reputation icon * on the left hand side - you can add to my reputation here

    If you have a solution to your thread - Please mark your thread solved do the following: >
    Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

  3. #3
    Forum Contributor
    Join Date
    04-27-2014
    Location
    england
    MS-Off Ver
    excel 2003,2016 and google sheets
    Posts
    112

    Re: Find number equal to or grater then (not less then)

    Yeah should be fine sorting sheet2, take it I just need it highest to lowest, will have a look at the sheet you done once I get back to my laptop, only can use google sheets at the min as on iPad, thanks for your help.

  4. #4
    Forum Contributor
    Join Date
    04-27-2014
    Location
    england
    MS-Off Ver
    excel 2003,2016 and google sheets
    Posts
    112

    Re: Find number equal to or grater then (not less then)

    hey check that out it works perfect thanks for your help.

  5. #5
    Forum Expert etaf's Avatar
    Join Date
    10-22-2004
    Location
    Surrey, UK
    Posts
    4,889

    Re: Find number equal to or grater then (not less then)

    you are welcome

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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