Explore

If name & date match -> change value

Compare

Table A

⁠

Table B

⁠

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

Table A

Row

Date

Name

Value

7/1/2021

Name 1

Value A

7/1/2021

Name 2

Value A

7/2/2021

Name 1

Value A

7/2/2021

Name 2

Value A

7/3/2021

Name 1

Value A

7/3/2021

Name 2

Value A

7/4/2021

Name 1

Value A

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

Table B

Row

Name

Start Date

End Date

Date list

Value

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 select list

Name

Name 1

Name 2

Name 3

There are no rows in this table

⁠

Value select list

Value select list

Value

Value A

Value B

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.