I need to create a formula that will pull data from one worksheet into another worskheet, but with some very specific parameters:
1. It must first check the STATUS column, and if the word SOLD is there, it will check for the next parameter. If the cell is blank, it will know that this line of data is not required and not pull it.
2. If the previous function found the word SOLD, then the formula goes to the BILLED column, and checks to see if the cell is blank. If it is not blank, it will know that this line of dat is not requred and not pull it. However, IF there is data in this cell, it will pull all the information from this row into the other worksheet.
I hope that is clear.