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.
can you sort sheet 2
=INDEX(Sheet2!A:A,MATCH(Sheet1!A9,Sheet2!A:A,-1))
Wayne
if my assistance has helped, and only if you wish to , there is an "* Add Reputation" 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.
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.
hey check that out it works perfect thanks for your help.
you are welcome
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks