i'm trying to return a value that matches one criteria exactly, and the second by greater than or equal to. I created two tables below for reference, what I need to do is be able to match the ID # exactly, then find the Encounter date from the second table that is equal to or greater than the enrollment date in table 1, and return the value. Any help would be appreciated.
Table 1
<tbody>
</tbody>
Table 2
<tbody>
</tbody>
Table 1
ID Number | Enrollment Date |
AR-AB20396* | 10/3/2018 |
AT-AB37900* | 2/22/2019 |
BC-AB14407 | 10/5/2018 |
CC-AB14345* | 10/5/2018 |
CJ-AB14904* | 10/3/2018 |
<tbody>
</tbody>
Table 2
ID # | ENCOUNTER DATE | Value |
AR-AB20396* | 9/12/2018 | 5.5 |
AT-AB37900* | 2/22/2019 | 5.3 |
BC-AB14407 | 5/4/2018 | 8.3 |
BC-AB14407 | 7/31/2018 | 7.7 |
BC-AB14407 | 10/12/2018 | 7.7 |
BC-AB14407 | 3/4/2019 | 8.4 |
CC-AB14345* | 4/17/2018 | 7 |
CC-AB14345* | 7/30/2018 | 6.8 |
CC-AB14345* | 8/2/2018 | 6.8 |
CC-AB14345* | 12/4/2018 | 6.8 |
CJ-AB14904* | 1/17/2018 | 6.4 |
CJ-AB14904* | 5/13/2018 | 7 |
CS-AB35454 | 6/26/2018 | 6.9 |
<tbody>
</tbody>