Feb 27 2022 02:01 PM
Hello.
I have an issue with infrequent data being fed from a sensor at 5 minute intervals into a pivot table (See fig.1). Many times the data does not populate for some reason or the other and it provides a blank value.
I am using a VLOOKUP to reflect the data on another table that has specific times for input. Since the pivot table doesn't always have data at that specific time, it returns no value. (See fig.2)
What I would like to do is have the VLOOKUP grab the closest data to the specific time and reflect that value in the table. My current VLOOKUP formula is =IFERROR(VLOOKUP(B11,Sys.PvSCD!A:B,2,TRUE),"-")
Feb 27 2022 03:47 PM
Feb 27 2022 04:35 PM
Sorry a lot of that went over my head. I'm kind of learning as I go. But yes any value before or after the specific time would be fine. I just need closest to.
You're saying not to use VLookup?
Feb 27 2022 06:31 PM
SolutionFeb 28 2022 09:12 AM
Feb 27 2022 06:31 PM
Solution