• 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.

Populate cells based on condition of another range

N

ninad7

Member
Hi,


On Sheet1 I have a range A1:D10 (A1:D1 is the header row) and A2:D10 are values. Columns B and C take a value from 1-5, both inclusive.


On Sheet2 is a range A1:E5. What I am looking to do is if Sheet1!B2 = 1 and Sheet!C2 = 3, then from the bottom left cell (i.e. A5) go 1 cell right (A5 to be treated as 1) and 3 cells up and enter the value of Sheet1!A2. If there is already any text in this cell, then append to the existing text on a New Line.


Do this for entire range.


TIA.


Regards,


Ninad.
 
Hi, ninad7!


I didn't fully understand your requirment. The doubts:

- what if Sheet1!B2<>1 or Sheet1!C2<>3?

- with "append to the existing text on a New Line" you mean to add a CR+LF and add to the same cell, or store it in cell at next row same column?


Consider uploading a sample file (including manual examples of desired output), it'd be very useful for those who read this and might be able to help you. Thank you.


Give a look at the second green sticky post at this forums main page for uploading guidelines.


Regards!
 
You must log in or register to reply here.
Back
Top