Table 1:
<tbody>
</tbody>
Table 2:
<tbody>
</tbody>
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!
| Date | Code | Price | Ideal Price |
| 01/01/2017 | 7 | ? | 0 |
| 02/02/2017 | 4 | ? | 0 |
| 03/03/2017 | 7 | ? | 80 |
<tbody>
</tbody>
Table 2:
| Sale Date | Code | Price |
| 01/10/2017 | 4 | $70 |
| 03/02/2017 | 4 | $65 |
| 03/06/2017 | 7 | $80 |
<tbody>
</tbody>
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!
