I’m trying to create a control that changes a value if a name & date match, but I can’t come up with the correct formula.
I have 2 tables, Table A and Table B. Both tables have names and dates in them. If a name & date from Table B matches with name & date from Table A, then I want to change a value in Table A to the value from Table B.
An added difficulty is that I’m comparing a single date (from Table A) to a date range (from Table B).
Please see the sample doc below:
I hope someone can point me in the right direction?