LookupValue Query

[gmazza76]

Good afternoon,

I am using a lookupvalue to pull information through from another table, but I have come across an issue with looking at a column with time in.
I can match the time exactly which is great but am wondering how I can do a filter with a give of 1 minutes.

I am using the following formula which works if the time in 'Mainsheet' and SourceSheet match, but I need to be able to do 'Mainsheet' within a 1 minute difference as there is a time delay of the data saving from one set of info to another.

LOOKUPVALUE(sourcesheet[description],sourcesheet[Date],'MainSheet'[Date],sourcesheet[Time],'MainSheet'[Time],sourcesheet[No],Mainsheet'[No],sourcesheet[RANK],1))
[code/]

thanks in advance
Gavin

 

[C Moore]

Can you use a filter to dynamically filter your table?