Simone Carletti
Reputation
918
Top tag
Next privilege 1,000 Rep.
 Apr 14 awarded Nice Question Jul 24 awarded Popular Question Nov 15 awarded Scholar Nov 15 accepted Find the closest value (equal or greater) in a range in Google Spreadsheets Nov 15 comment Find the closest value (equal or greater) in a range in Google Spreadsheets `QUERY` worked like a charm. Thank you! Nov 11 asked Mark multiple messages as read in Inbox by Gmail Nov 6 awarded Student Nov 6 comment Find the closest value (equal or greater) in a range in Google Spreadsheets As I said, the value for B cannot be pre-determined from A, take it as a requirement. Nov 6 awarded Commentator Nov 6 comment Find the closest value (equal or greater) in a range in Google Spreadsheets No. It's just an example, the factor must be taken from the row, not calculated with an expression. In fact, the rule you provided would not work for feet. Nov 6 comment Find the closest value (equal or greater) in a range in Google Spreadsheets No, it does not. Apart that the fields where completely wrong, I was able to reuse `INDEX` to simplify the formula into `=IF(ISNUMBER(A4),INDEX(SAC!E:F,(MATCH(A4, SAC!E:E, -1)), 2),)`, but it still doesn't fix the problem of the order. If I sort with `0` and I don't use the field sorted in reverse range, it does not select the right value. Nov 6 revised Find the closest value (equal or greater) in a range in Google Spreadsheets deleted 1 character in body Nov 6 comment Find the closest value (equal or greater) in a range in Google Spreadsheets 6 and 10 are just examples, the formula should work for any value in the depth range, not just for 6/10. Nov 6 asked Find the closest value (equal or greater) in a range in Google Spreadsheets Oct 23 awarded Revival Oct 23 awarded Yearling Mar 18 awarded Custodian Mar 18 reviewed Approve How do I migrate my Google Calendar & Contacts to Outlook.com? Jan 12 answered Are there any advanced options for searching my Delicious links? Dec 13 answered How do I migrate my Google Calendar & Contacts to Outlook.com?