Hi,
I have two tables, one with reference data that is continuously updating [reftbl] and another where I am trying to summarise the data [summary]. I want to look up a date range in [reftbl] based on a month and year in [summary] then with the rows it returns look for another value within that range and produce what should be one answer. Example data below:
[reftbl]
1.PNG
[summary]
2.PNG
I want to put the answer into Return Data column. Basic idea: if column "date" value in [reftbl] is between +- 30 days of value in "month' column in [summary] then look for corresponding "SP N" value in [reftbl] and return "val".
Bookmarks