阅读背景:

使用IF从另一个表复制列

来源:互联网 

I have 2 sheets, let's say column A is item ID, column B is owner of the item. In the first sheet the column B is empty, so I need to copy column B from another sheet. I don't know if they are both ordered the same, probably yes, they appear they might be. I used IF function, IF cell-ID in the first sheet is equal to cell-ID in the second sheet and the cell-owner in the second sheet is not empty then cell-owner in the first sheet is equal to the one in the second sheet. How would I make sure that this function would work even if the order of data was different?I have 2 sheets, let's say column A is item ID,




你的当前访问异常,请进行认证后继续阅读剩余内容。

分享到: