My students record the daily temperature as an ongoing class project. We are using VLOOKUP(32, Jan!B2:C32,2,FALSE) to find out the first time the temp drops to 32 or below each month (lookup formula changes). The problem is that the function only locates the date that we hit 32, sometimes our temp may fall below that before we record a day with 32. Is it possible to use VLOOKUP or do I need to try something new?
Thank you
Brenda
Bookmarks