Forum Discussion
Solved
Copy cells to second sheet based on condition on one cell from first cell
Good Afternoon all! I have Sheet1 with columns from A to O and the I column is Shipping Status. If I column value is Ready To Ship or Ready for P/U, I need columns/cells B, I , J, K, L M, N, O t...
In A2 on Sheet2:
=CHOOSECOLS(FILTER(Sheet1!$A$2:$O$1000, (Sheet1!$I$2:$I$1000="Ready to Ship")+(Sheet1!$I$2:$I$1000="Ready for P/U"), ""), 2, 9, 10, 11, 12, 13, 14, 15)
Thanks much appreciated! It worked.
MSTS0022 , you are welcome