Reputation
873
Top tag
Next privilege 1,000 Rep.
See votes, expandable usercard
Badges
5 16
Impact
~57k people reached

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?
Nov
25
awarded  Caucus