Hi there,
I have spend a long time trying to figure this out and struggled to find anything online... This is the first time I have posted something on here, so thanks in advance for any help!
Basically I have 2 columns of data:
Col A --> minute by minute data (hh:mm format, military time)
Col B --> corresponding temperature value for this time (may be to +2dp)
I have a separate table in which i can enter a time value hh:mm (cell E5) and then the next cell will return the corresponding Temp Value using the formula:
=VLOOKUP(E5,$A$2:$B$32,2)
HOWEVER, this formula works great for times up to 23:59 but returns #N/A for times >= 00:00
I need this to be able to work over midnight. I'd appreciate any help!
Thanks!
Bookmarks