• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Array Formula for copy value from 1 sheet to another

Status
Not open for further replies.

jack999

Member
Can someone kindly help to fill the array formula to accomplish to result

In the sample excel file 3 columns I have filled

IN SHEET1 column D5 NEED FORMULA as Sheet1 B2 NAME=SHEET2 RAGE C:C AND SHEET1 F:F RAGE VALUE=PURCHASE OR SALES RETURN THEN VALUE FROM DATA2 SHEET COLUMN E: (QTY) COME IN REPORT SHEET D COLUM (INWARD)

IN SHEET1 E5 NEED FORMULA as Sheet1 B2 NAME=SHEET2 RANE C:C AND SHEET1 F:F RANGE VALUE=SALE = OR SCHEM, FOC THEN VALU FROM DATA2 SHEET COLUMN E: (QTY) COME IN REPORT SHEET E (OUTWARD)

thanks
 

Attachments

Status
Not open for further replies.
Top