Hi, i have a list that I am trying to use an if function on another tab to only bring across certain lines. I'm trying to get. For example if cell G2 says X,y or z and H2 is blank and i2 is not blank then put value A2. But I can't seem to get my formula to work for the G2 criteria. It work fine separately. Also how do I get it so that when I copy it down that it will not show false lines and put the true results one after each other. Thank you.
