Gallery
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
1
7/1/2021
Name 1
Value A
2
2
7/1/2021
Name 2
Value A
3
3
7/2/2021
Name 1
Value A
4
4
7/2/2021
Name 2
Value A
5
5
7/3/2021
Name 1
Value A
6
6
7/3/2021
Name 2
Value A
7
7
7/4/2021
Name 1
Value A
8
8
7/4/2021
Name 2
Value A
There are no rows in this table
⁠
⁠
Change value
⁠
👆 this is the control where the magic should happen (for now a placeholder)
Table B
Row
Name
Start Date
End Date
Date list
Value
1
1
Name 1
7/3/2021
7/6/2021
7/3/20217/4/20217/5/20217/6/2021
Value 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
Name
1
Name 1
2
Name 2
3
Name 3
There are no rows in this table
⁠
Value select list
Value
1
Value A
2
Value B
3
Value C
There are no rows in this table
⁠
Want to print your doc?
This is not the way.
Try clicking the ⋯ next to your doc name or using a keyboard shortcut (
CtrlP
) instead.