[算表] 不同期的资料查询

楼主: Monihulk (MoniHulk)   2019-10-01 19:29:47
软件:EXCEL
版本:2016
如图说明,请问如何在输入期数后,产出需要的表格资料,不限定LOOKUP函数,谢谢
https://i.imgur.com/0NdDn4P.jpg
作者: soyoso (我是耀宗)   2019-10-01 19:49:00
https://i.imgur.com/oZTy7kU.jpg offset、index或indirect配合match或是 https://i.imgur.com/PYXYWn3.jpg
楼主: Monihulk (MoniHulk)   2019-10-01 21:20:00
了解了,2种方法都很不错,谢谢S大

Links booklink

Contact Us: admin [ a t ] ucptt.com