Hi everyone, is it possible to do a copy if function? I have a table consisting of several giant columns of data. I want to copy the dividend and volatility columns, but ONLY IF the volatility column has a value greater than 0. So for example, if the dividends are column H and the volatility is column I, and cell I5 has a value of 0, then it will not copy over H5 or I5, regardless of what the corresponding value in H5 is. Likewise, if cell I5 has any value greater than 0, it will copy both the values of H5 and I5, regardless of the value in H5. Additionally, can it be done so that there are not huge gaps between the data? I've read something about using a combination of MATCH and OFFSET functions, but I have no idea what these functions are or if they could even work. Does anybody know how it might be possible to do this?