MS Excel closest match lookup
Posted on 2013-01-11
Take this example:
Alison Natalie Ross Actual Mins Late Closest
10/01/2013 09:15 09:06 09:09 09:08 8 Ross
11/01/2013 09:03 09:09 09:06 09:06 6 Ross
I want to automatically put the name of the person who was closest to the estimated time in the "closest" cell once a value is entered in the "actual" time field. IE, check that days times, compare to "actual", and grab the name of who's "closest".
I'm completely stuck with how to do this - I guess it's something to do with a vlookup and an index, but I've never used index!
Thanks all :)