How to Do a Reverse Vlookup in Google Sheets
How to Do a Reverse Vlookup in Google Sheets
Prepare your data.
minutes
hours
Figure out what value you want to lookup.
minutes
minutes
Use the filter function.
minutes
hours
Get the highest row from the filter function by using the MAX function.
minutes
hours
Use the INDEX function to get the value out of the row you discovered using MAX and FILTER.
days
hours