Table 1:
[TABLE="class: grid, width: 500, align: left"]
<tbody>[TR]
[TD]Date[/TD]
[TD]Code[/TD]
[TD]Price[/TD]
[TD]Ideal Price[/TD]
[/TR]
[TR]
[TD]01/01/2017[/TD]
[TD]7[/TD]
[TD]?[/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD]02/02/2017[/TD]
[TD]4[/TD]
[TD]?[/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD]03/03/2017[/TD]
[TD]7[/TD]
[TD]?[/TD]
[TD]80[/TD]
[/TR]
</tbody>[/TABLE]
Table 2:
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]Sale Date[/TD]
[TD]Code[/TD]
[TD]Price[/TD]
[/TR]
[TR]
[TD]01/10/2017[/TD]
[TD]4[/TD]
[TD]$70[/TD]
[/TR]
[TR]
[TD]03/02/2017[/TD]
[TD]4[/TD]
[TD]$65[/TD]
[/TR]
[TR]
[TD]03/06/2017[/TD]
[TD]7[/TD]
[TD]$80[/TD]
[/TR]
</tbody>[/TABLE]
I want to populate table 1 prices based on a combination of matching codes and a matching date range, say +/-10 days.
I think I might need an array formula that will allow me to search for codes within an array of rows that meet the date criteria but I'm a rookie and I'm not sure I understand how those work. Thanks!
[TABLE="class: grid, width: 500, align: left"]
<tbody>[TR]
[TD]Date[/TD]
[TD]Code[/TD]
[TD]Price[/TD]
[TD]Ideal Price[/TD]
[/TR]
[TR]
[TD]01/01/2017[/TD]
[TD]7[/TD]
[TD]?[/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD]02/02/2017[/TD]
[TD]4[/TD]
[TD]?[/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD]03/03/2017[/TD]
[TD]7[/TD]
[TD]?[/TD]
[TD]80[/TD]
[/TR]
</tbody>[/TABLE]
Table 2:
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]Sale Date[/TD]
[TD]Code[/TD]
[TD]Price[/TD]
[/TR]
[TR]
[TD]01/10/2017[/TD]
[TD]4[/TD]
[TD]$70[/TD]
[/TR]
[TR]
[TD]03/02/2017[/TD]
[TD]4[/TD]
[TD]$65[/TD]
[/TR]
[TR]
[TD]03/06/2017[/TD]
[TD]7[/TD]
[TD]$80[/TD]
[/TR]
</tbody>[/TABLE]
I want to populate table 1 prices based on a combination of matching codes and a matching date range, say +/-10 days.
I think I might need an array formula that will allow me to search for codes within an array of rows that meet the date criteria but I'm a rookie and I'm not sure I understand how those work. Thanks!