pulling data from a table based on conditions.

%3CLINGO-SUB%20id%3D%22lingo-sub-2333163%22%20slang%3D%22en-US%22%3Epulling%20data%20from%20a%20table%20based%20on%20conditions.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2333163%22%20slang%3D%22en-US%22%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20trying%20to%20pull%20data%20from%20the%20table%20at%20the%20top%20right%20to%20the%20row%20dated%205%2F3%2F2021.%20The%20other%20rows%20are%20being%20populated%20using%20another%20table%2C%20but%20if%20there%20is%20no%20data%20available%20based%20on%20date%20and%20code%2C%20I%20need%20to%20pull%20in%20the%20data%20that%20it%20entered.%20Any%20idea%20how%20I%20can%20do%20that%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIn%20addition%2C%20item%205d%20looks%20that%20the%20difference%20from%20the%20day%20before.%20Any%20idea%20how%20I%20can%20have%20it%20leave%20it%20blank%20if%20there%20is%20no%20data%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22datawizsmh_0-1620336053597.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F278914i4E078A3C3E920C92%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22datawizsmh_0-1620336053597.png%22%20alt%3D%22datawizsmh_0-1620336053597.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2333163%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2340121%22%20slang%3D%22en-US%22%3ERe%3A%20pulling%20data%20from%20a%20table%20based%20on%20conditions.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2340121%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1047173%22%20target%3D%22_blank%22%3E%40datawizsmh%3C%2FA%3E%26nbsp%3B%2C%20I%20hope%20that%20I%20understood%20your%20request.%26nbsp%3B%20See%20revised%20sample.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECheers%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional 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