pulling data from a table based on conditions.

Copper Contributor

 

I am trying to pull data from the table at the top right to the row dated 5/3/2021. The other rows are being populated using another table, but if there is no data available based on date and code, I need to pull in the data that it entered. Any idea how I can do that?

 

In addition, item 5d looks that the difference from the day before. Any idea how I can have it leave it blank if there is no data?

 

 

datawizsmh_0-1620336053597.png

 

1 Reply

@datawizsmh , I hope that I understood your request.  See revised sample.

 

Cheers