Excel Magic Trick 1191


VLOOKUP: Lookup Temperature and Return to Bat Observation Table

DESCRIPTION

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.
Solution:
VLOOKUP function with Approximate Match.

WORKBOOKS




Be the first to comment

Leave a Reply