Excel Magic Trick 1192


Match Lookup Value to Closest Number in 1st Column of Lookup Table

DESCRIPTION

What to do if you need to match Lookup Value to Closest Number in 1st Column of Lookup Table:
(00:10) Problem Set Up
(01:30) Use MROUND on lookup value to round Date-Time to nearest 5 minutes
(03:30) Custom Number Format to show Date and Time in cell
(04:18) LOOKUP Function to handle array operation and do Approximate Match lookup, and to use lookup_vector and result_vector arguments.
(05:58) What makes an array operation different than a normal non-array operation.
(07:25) Use MROUND on Array Calculation to create a lookup_vector column that can be matched against the MROUND lookup value.

WORKBOOKS




Be the first to comment

Leave a Reply