IF STATMENT HELP NEEDED

%3CLINGO-SUB%20id%3D%22lingo-sub-1838025%22%20slang%3D%22en-US%22%3EIF%20STATMENT%20HELP%20NEEDED%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1838025%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20this%20is%20Shohidul%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI'm%20looking%20for%20excel%20formula%20to%20get%20the%20specific%20data%20form%20other%20cell%20based%20on%20the%20%22if%20else%22%20logic.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ewhat%20I'm%20trying%20to%20do%20here%2C%20if%20%22Status%22%20is%20%22Ready%20to%20stitch%22%20i%20need%20the%20date%20from%20other%20cell%20into%20the%20Remarks%20column.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ebelow%20snapshot%20for%20easy%20review.%20could%20you%20please%20help%20me%20here.%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%22excel%20formula.PNG%22%20style%3D%22width%3A%20930px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F230445iF83DBA790EE3FEC4%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22excel%20formula.PNG%22%20alt%3D%22excel%20formula.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-1838025%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

Hi this is Shohidul,

 

I'm looking for excel formula to get the specific data form other cell based on the "if else" logic.

 

what I'm trying to do here, if "Status" is "Ready to stitch" i need the date from other cell into the Remarks column. 

 

below snapshot for easy review. could you please help me here. 

 

excel formula.PNG

 

0 Replies