Excel Magic Trick 1191

VLOOKUP: Lookup Temperature and Return to Bat Observation Table


In this example we have Date Set 1 with Bat Observation Date-Times and we need to lookup the Date-Time in a second Data Set with Date Times and Temperatures and return the Temperature to Date Set 1 with Bat Observation.
VLOOKUP function with Approximate Match.


Be the first to comment

Leave a Reply