阅读背景:

从单元格地址获取单元格值,该单元格地址再次具有要查找的值的单元格地址

来源:互联网 

I have a cell, lets say B2. B2 has an address, lets say A1. The value at A1 is, lets say 5. I need to obtain this value i.e. 5 from cell B2. I have tried INDIRECT adn ADDRESS but somehow i dont seem to find a right combination. Any help would be appreciated.I have a cell, lets say B2. B2 has an address,




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

分享到: