Here's what I am trying to do. I think these have similar solutions, I just think I am missing the obvious answer.
1. (This needs to go in cell L22). If C22="C560", then copy J22. If J22 has no data, then be blank.
2. (This needs to go in cell M22). If C22="C560" AND K22>0, then copy K22. If K22 has no data, then be blank.
Thank you in advance!!
1. (This needs to go in cell L22). If C22="C560", then copy J22. If J22 has no data, then be blank.
2. (This needs to go in cell M22). If C22="C560" AND K22>0, then copy K22. If K22 has no data, then be blank.
Thank you in advance!!