Looking up multiple values on

Last Edited By Krjb Donovan
Last Updated: Mar 05, 2014 09:44 PM GMT


I'm lookng for a function that can look up 3 values across columns (the date, location, and location activity) and return a corresponding value (distance).

Please help.


if it is a unique combination then

Values being sought

M1: date N1: location O1: location activity

lookup in Column A: date Column B: Location Column C: Location Activity Column D: distance

data in rows 2 to 5000


if you have2007 or later then


would be faster


©2023 eLuminary LLC. All rights reserved.