Match/Index N/A error

Occasional Visitor

Screenshot 2022-04-08 110711.pngI have two sets of data that I need to match together (observation time with corresponding weather data). I used Mround to round observation time to hourly to match weather data before using match & index to find the corresponding weather data. the problem is that this only works for 2/3 of the data, with #N/a error for the remainder. I know the data is in the table so I presume its some kind of format/data type error but have been unable to fix it.

0 Replies