Skip to content
Share
Explore

If name & date match -> change value



Compare
Table A
⁠
to
Table B
⁠
:

IF
a name in
Table A
⁠
is also in
Table B
⁠
AND
the date from that name in
Table A
⁠
is also part of the date list from that name in
Table B
⁠

THEN:
Change the Value in
Table A
⁠
to the Value from that name in
Table B
⁠

So in the example below, the value of row 5 and row 7 from
Table A
⁠
(=
@Value A
⁠
) should change to
@Value B
⁠

(because they are both
@Name 1
⁠
and dates "7/3/2021" & "7/4/2021" are part of Date list in row 1 in
Table B
⁠
)

Table A
Row
Date
Name
Value
1
7/1/2021
2
7/1/2021
3
7/2/2021
4
7/2/2021
5
7/3/2021
6
7/3/2021
7
7/4/2021
8
7/4/2021
There are no rows in this table
⁠
⁠
⁠
👆 this is the control where the magic should happen (for now a placeholder)
Table B
There are no rows in this table
⁠

FYI: column Date list = a list of all dates between Start Date and End Date








Name select list
There are no rows in this table
⁠
Value select list
There are no rows in this table
⁠
Want to print your doc?
This is not the way.
Try clicking the ··· in the right corner or using a keyboard shortcut (
CtrlP
) instead.